-
Date formula using Today
Hi, I want a formula to show how long a project has been running. For example, I want: Today - the start date = X number of business days. 8/5/21 - 7/20/21 = 12 business days How do I write a formula for this in Smartsheet? Thank you!
-
How to count cells with a value in a column
Hello, Trying to figure out how to count cells with values in one column. For example: I want to know how many cells contain a value on the following: Column 2 Josh Robert Alexandra Greg My ideal answer would be that there are 4 values in column 2. Any idea what the formula is for this? I have the formula for blank cells:…
-
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…