-
Project stage and date in the Future
Hello Smartsheet super formula humans! I need some assistance! We are trying to create a formula where a checkbox is checked if the project meets the below criteria. Recurring On hold Pending approval + In Progress with a Go-Live date of after 3/31/21 The Recurring is its own checkbox without a formula, the On Hold,…
-
Formula to Automatically Return Column Pending
I have a Smartsheet that is being used to login dates as an item is processed through various steps until completion. I would like to create a column that automatically shows what step in the process the item is on. I can do this by combining if/then formulas, but there are at least 15 steps and I am hoping there might be…
-
How do I use IF formula to change a colour based on a percentage column?
I have a status column with red, yellow and green. I'm needing a formula to change these colours when the percentage complete column gets below a certain percentage. i.e. 1-50% Red 51%-99% Yellow 100% Green
-
How would I update a row status based on what has been checkmarked in the same row/multiple columns?
Hi everyone! Need some help with this one, I've been stuck on it for days! Essentially what I'd like to happen is we are having a process that must happen in chronological order (starting at Page Created to the right). What we'd like to accomplish is the Overall Status to update based on what has been completed (check…
-
count tasks "on fly" per work week.
Hello Gentlemans , Do someone can give direction on how to count tasks "on fly" per work week. Example; task start 28.07.20 finish 28.08.20, this task will include in count WW31,32,33 and 34 till its finished. task start 10.08.20 finish 20.08.20. ww31 ww32 ww 33 ww34 1 task 2 tasks 2 tasks 1 task
-
CountIFs
Hi I am trying to do a count if to see the following if the value selected is Milestone and the status selected is Complete at the moment I have tried this =COUNTIFS(Value:Value, "Milestone", Status:Status, "Complete") but its returns an unparsable or circular ref and the also blocks the formula I have to see the total…
-
Can I set the default value for a drop down list to be a formula in a form?
I am creating a SmartSheet whose rows are filled with the submission of the form and I wanted to utilize the hidden feature of the form to autofill a field when the form is submitted. I wanted this field to hold a formula that would select a value from a dropdown menu upon submission of the form but every time I submit the…
-
Formula to update a cell
I want my column for progress (Not started - In progress - Complete) to update when someone adds the % complete. So is "0" then read "Not Started", If < the 0 but not 100% then "In Progress" and if 100% then "Complete". Does anyone know that formula?
-
Parent Row % Complete Doesn't make any sense
See attached image The Parent Row shows 7% complete based on the 1 item being 100% and all other items being in the future. The target % complete shows 20% which makes no sense to me. There is a formula for Target % complete: =IFERROR(IF(Status@row <> "Completed", IF(NETDAYS([Today (hidden)]$1, [Planned End]@row) /…
-
Formula to return the logged in user
Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODAY(), "")can we have something like =IF(Closed1 = 1, Logged user, "") I know that there…