-
Formula: Turn Sprint # into Date or vice versa
I'm attempting to create a formula that will translate Start Date into sprint number. In my spreadsheet there is a column for Sprint that I'd like to populate it with Sprint 1, Sprint 2, Sprint 3, etc based on date. For example Sprint 1's start date is 12/11/19, Sprint 2's start date is 12/25/19, etc, increasing in two…
-
Adding formula to existing formula for status change
Hi everyone, I currently have a formula in my status column that auto-update depends on the percentage completion. Anything that is 0 is Not Started, and greater than 0% and less than 100% is Green (G), and anything that is 100% is Complete (blue). I want to add 2 more actions in the formula. If Finish Date is in the past,…
-
Insert Formula within Workday "num_days" string
Hey, This may be super simple & this feature is available in excel, so I think i am just missing something in front of the "-1" for Smartsheet to pick up a formula. I am trying to calculate the day for a "test" shipment to arrive, based on 3 factors - 1. workday (with holidays), 2. Scheduled delivery date of devices, and #…
-
Need Workaround Ideas for Automation Condition
Client submits file through form. I have an automation set up to respond to client when new file w/response is attached to row and "Status" and "Date" cells @row are populated. It works as intended but relies on people to always set those 2 fields and save before attaching the file to the row. Without the conditions set,…
-
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