-
Identifying specific combinations from a multi-select field
Good morning, fellow Smartsheeters. I have a master roadmap sheet that we use to populate numerous dashboards and reports. One of the columns on this roadmap is Project Type. It is a multi select drop down with the following values: Revenue Opportunity, Revenue Loss Avoidance, Risk Compliance & Cost Savings The…
-
Formula for connecting Checkbox columns with Health column
I am looking to connect both Checkbox columns with the Health column. These are the formulas I am looking for. If Nothing is checked off, Health = Red If SO Submitted = checked, Health = Yellow If Done = checked, Health = Green
-
I want sync a field across multiple sheet, being able to edit it from any of those sheets
Use case. 4 sheets Intake Sheet, Prioritization sheet, Resource sheet & Overall Status Sheet When a project is requested it is automatically added to the "Intake" sheet through the form. Status field is New. When we agree that the team will work on it - we add the Unique identifier to the "Prioritization" sheet and the…
-
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…