-
Unable to conditionally auto populate a symbol column
Hi, I have been trying to auto-populate the health column (symbols red/blue/green/yellow) using status column dropdown value using the below formula, but it is not parsed. Can you please help? =IF([Status]2=βNot Startedβ, βRedβ, IF([Status]2=βWaiting/Blockedβ,βBlueβ,IF([Status]2= βIn Progressβ, βYellowβ,IF([Status]2=β¦
-
Cross Sheet reference/"assigned to" allow multiple contacts per cell LIKE formula?
SS community - I need help. I have created a Sales Pipeline sheet for my sales team, sales stages etc which is basically it's own CRM. I am trying to gain metrics in order to keep the sales team members honest and report the truth to the leadership team. Challenge: Cross sheet formula (below) pulls correct data but whenβ¦
-
Calculate cumulative duration of time spent in each status where status changes are bidirectional
Hi, I have a problem I am trying to solve in a sheet that contains hundreds of individual requests. Each request starts with Status = 'New' and finishes at Status = "Complete" in between there are 3 review statuses, "Review Department A", "Review Department B", "Review Department C" depending on the department the reviewβ¦
-
Can you scan/update info behind a dynamic QR code?
Does anyone know if Smartsheet has a way to scan a dynamic QR code and update the information associated with it? I'm guessing there would be a sheet of raw data and a secondary sheet that backs the dynamic QR code that mines the most recent data from the raw data sheet. Any ideas appreciated!
-
How to write a formula that automatically updates a specific cell
@Paul Newcome Is a formula possible to achieve the following automation? I am trying to set up a workflow that when a due date+1day is reached and the status isn't complete that a cell update is triggered to update the symbol in the heath column to the red stop sign from the green. Update the Health column to either a red,β¦
-
How to auto populate the month and year based on a date mm/dd/yy
Hello, I have a date column (mm/dd/yy) and would like to auto populate the month in a separate column as well as the year in another column. What formula can I use for this? Thank you!
-
Countifs without including duplicates
Hello, Im trying to get information to show on a dashboard that breaks down events by type and date range. I was able to get the following formula to work on a roll up sheet: =COUNTIFS({[sheet] Range 2}, <=DATE(2021, 1, 31), {[sheet] Range 2}, >=DATE(2021, 1, 1), {[sheet] Range 1}, "task type") the problem is that multipleβ¦
-
Is there a way to auto fill down rows that have matching criteria?
I have a risk assessment where some folks will only be scoring at the risk/bu level, so because the data won't vary based on risk factor I would like the rows to fill down for each risk area/BU as users enter in controls scores. For example could I have a flag that if checked the assessment scores will auto populate all ofβ¦
-
Pulling Adjacent Cells
Hello, I have a column of task due dates, and an adjacent column that lists who the tasks are assigned to. In a separate column, I have a cell that shows the next upcoming due date using a formula. I would like to pull in a cell next to that the corresponding person that that next upcoming due date is assigned to. Whichβ¦
-
Duplicates from a a previous date
Hi All, I'm currently trying to create a formula to count a row as a duplicate if the same information was entered the day before. Example: [Duplicate 2] formula is currently the following (but I know is wrong): =IF(COUNTIFS(Orders:Orders, Orders@row, Date:Date, Date@row, Reasons:Reasons, Reasons@row) > 1, 1, 0) I want theβ¦