-
Calculate with dates
Hey smartsheet-community, I am trying to create a sheet where the end date is fixed. From there, I want to subtract different number of days (at best only working days) based on the complexity of individual steps and thus get the date at the end on which the project should start. Here an example that hopefully helps to…
-
Count a Checkbox and a value
Hi there I have a sheet that inidcates the level of a student and whether they have secured an internship. The first value is their academic level and the second value is a simple checkbox. I am trying to count them but not getting very far - I can count the number of checkboxs and I can count the number based on level but…
-
How do I get a Cell to change its (dropdown) contents triggered off a checkbox?
I tried using a workflow to trigger the cell to change its contents to one of the dropdown options, but it won't take. Do I need to use a formula instead? Or maybe I am overlooking something? Any help would be appreciated - Looking to have the HVAC Refresh complete trigger the HVAC Status to change to 'complete.'
-
Add days to a date
Hi, I am trying to create a column that adds a certain number of days to a date. When I use =[Task start date]@row +7 . It doesn't add 7 days to the date, instead just adds the number 7 to the end of the date. I have also tried to use the WORKDAY formula as an alternative, =WORKDAY(Task start date]10, 5) . This results in…
-
Need with formulas
Good day Community, I have a spreadsheet where I need to know; From a Date, how many days are: Age at time of approval with Years and Months Column I will need to convert it into how many net days are. To know in years and months what's the CSPA at the time of approval I have it like this but it gives me decimals =[Age -…
-
Formula to populate a "Year" if Create date falls between 2 column dates
I created a form that request the Calendar year for funding. They range from 2022 to 2028 and each year has Quarters. Sample quarter is between April 15 - July 15 so if I want the formula to populate me a Calendar year 2022 if the create date falls between the April - July dates. Here is the formula that works but is…
-
generating a defined number of IDs
Dear Smartsheet community, I am trying to write a formula to generate a defined number of IDs. In the screenshot below, if I enter 6 into the blue squared cell, I would like that 6 IDs are generated with a number incrementing at the end (ID_1, ..., ID_6). if I enter 3, 3 labels are generated. (ID_1, ID_2, ID_3). How could…
-
How do I get a cell to change color based at certain increments based off of a date in a column?
I want to be able to change the color of date cells in a Smartsheet at 5 years and 9 years out from the install date in each row of a column. One the 5 year mark is reached after install - it changes the cell to yellow, and at 9 years it turns that cell to red once the 9 year mark is reached Not even sure where to start…
-
Formula Breakdown
Hi! I got the health status formula below from a WBS template I found on a Smartsheet community thread (I can't find the link to the template but will continue to look). Anyways, can someone break the formula down into layman terms of what it's saying? =IFERROR((IF(OR(Start@row = "", Start@row > TODAY()), "Blue", IF(OR([%…
-
Count Days Since Ticket Opened
Hello, Needing to calculate number of days since line item appeared when Date Submitted column is "Auto-Number/System Generated Column Created (Date)" -- and then display "Closed" when Checkbox is checked in Complete column. Can't get the "Complete" to appear -- just goes blank. =IFERROR(IF(Complete@row = 0, TODAY() -…
