I am trying to create a formula =Program Revenue+PY Rollover-Total Booked however I think because Program Revenue is also a formula it is causing an error. Help is appreciated.
I would suggest that you create a helper column that copies the amount from the Program Revenue column. You could hide it from view and then use that Program Revenue (Helper Column) in your formula above. Your helper column would essentially be =[Program Revenue]@row. And then right click on that helper cell formula to convert it to a column formula.
Try that out and it should work.
All the best!
Thanks, I was thinking that too, but wanted to see if there were any other options :)
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I need to calculate the number of Network Days based on a Leave Status but if a half day has been checked, it needs to just put 0.5. The formula I am currently using is: =IF(AND([Half Day]@row = 1) [Leave Type]@row = "TOIL", "0.5", NETWORKDAYS([Start Date]@row, [End Date]@row)) But I'm getting a #Unparsable error. What am…
Hi, hoping someone will be able to help with an issue I am having with an IF formula. I am attempting to build an IF formula from check boxes, however it isn't as simple as multiple IF statements returning their own responses. What I am trying to achieve is a status update column, based off of the checkboxes. And therefore…
I created a timesheet and a form to go along with it. When someone uses the form and flags that someone has called off, I want the flag to return zeros in the ST Hrs, OT Hrs, and DT Hrs cells. Using AI to generate the formula below, it returns a Circular Reference error when the formula is placed in the ST Hrs cell.
©2024. All Rights Reserved Smartsheet Inc.