How can I achieve this, that is, have Column 3 calculate the amount of Column 1 by Column 2? Example:
Column 1 = 2 hours
Column 2 = $400
Column 3 = $800
I don’t think so but you can get a definitive answer by emailing support — easily done from the menu: Help > Contact Omni
I don’t know whether you use applescript or not but you could use one to fill in column 3 — Pro version required. Here is an example.
tell application "OmniOutliner"
tell document 1 -- work with frontmost document
-- list of top level rows of document 1
set rowList to a reference to children of it
-- loop through each row in list
repeat with cc in rowList
tell cc -- for each row…
try -- should skip blank rows
set sum23 to (value of cell 2) * (value of cell 3) -- sum cell 2 and cell 3
set value of cell 4 of cc to sum23 -- set cell 4 to sum
end try
end tell
end repeat
end tell
end tell
Notes:
The first column (or cell of a row) is actually the space to the left of the ‘topic’ where you can see the ‘note’ icon (if there is one). This is why the script begins with cell 2.
The above assumes that the outline is simple and it attempts to process every row. It will skip over a blank row (or more specifically, rows that it can’t get a usable value out of cells 2 and 3). It could be made to evaluate only a select group of rows rather than every one in the outline.
There are a couple of different ways to run this, depending upon convenience. If you have any questions on this, let me know (or ask Omni).
Is there a reason a spreadsheet won’t do for your use case?
