I am updating information on to a sheet when I contact our customers AP dept either by email or Phone. The info I update includes Invoice- date- AP response. I want to use this data to link to another…
I am having a bit of trouble figuring out how to write a formula to automate RYG symbols. Basically I want the rules to be as follows: 1. If value is less than 4, RED 2. If value is greater than 4 but…
Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list. Thank you for your help, Sohlbe
I am using the first row for totals and it is throwing my auto numbering system off. Is there a way to have the auto number start on row 2? Alternatively, if I put my totals on the last row, the web f…
My totals were working finally on a summary sheet but then all the columns started changing to the same formula. I tried twice to go in and reset the reference sheet range but then it would just every…
Hi! I am attempting to create an "=If" formula that has 21 "if_then" statements. When I get to the end my formula enters as "Unparsable." Is there a limit to criteria in a formula? Thanks!
I am building a production scheduler with a built in calculator where by the operator can adjust the labour allocation to test the duration output. My problem is Smartsheet won't allow durations to be…
How can a change this formula to use children in a hierarchy instead of the cell references so when I add a row into the hierarchy it returns the correct value without re-setting the range? =SUMIF([CQ…
Hello, My name is James Smith. I am an Instructor for Gateway Community College in Phoenix, AZ. I am Looking for alternative methods to track time as student’s progress through our courses. I am not l…
I have a calculation for Total Hours that takes the DURATION (set to days) multiplied by UTILIZATION percent, then translates to hours by multiplying by 8 hrs. I want the result to always be a whole n…
