-
Automate Status Based on Due Date and Complete Date
I have a status column that uses the Red, Yellow, Green, and Blue symbols. I would like it to automatically update based on the dates in the Due Date and Compete Date columns. The parameters are as follows: If there is a Complete Date = Green If there is no Complete Date, AND Due Date is over 7 days away = Blue If there is…
-
Complicated IF statement
I'm trying to create a formula that will output a Product category. Below is the formula and I've provided a screenshot of the columns involved. =IF(AND(Folder1 ="default", [Cost Category]1="Printer : Plex", ISNUMBER(FIND("Color",[Cost Option]1))), "Color Impressions", If(AND(Folder1="default", [Cost Category]1="Printer :…
-
I cannot seem to cross reference a sheet to another sheet and im going insane
Hello I know this might be very simple but I have tried everything to cross post a value from one sheet to another and I always get the wrong ref error or the unparseable one, this is the formula I'm trying to use, please help. =COUNTIFS({RE Projects Range1}, "Counter", {RE Projects Range2}, "Complete")
-
Raffle Type System in a Smartsheet Form
I am looking at trying to build a multi-select option raffle form. Lets say a form user has 5 options or "tickets" they can put into a bucket of goods for a raffle. I would like for the user to put in any combination of entering tickets per good that they can with the five tickets they have. I will put in a picture of what…
-
Cross Sheet Formula For Averaging Total Turn Around Time
I’m looking for a cross-sheet formula in Smartsheet to calculate the average Turn Around Time (TAT) by specific Site Numbers. Source sheet details: Site Number (text/number) Turn Around Time (number; measured in days) Target sheet details: I have a row per site and want a formula in the Avg TAT column that returns the…
-
Counting Distinct Items in Sheet1 from Sheet2
I have a counting formula that's working in Sheet1. When I try to use that same formula in Sheet2 to pull the data from Sheet1, I get an UNPARSABLE error. What am I doing wrong? Original formula (in Sheet1): =COUNT(DISTINCT(COLLECT([Department]:[Department], [StartDate]:[StartDate], >=DATE(2025, 7, 1), [Status]:[Status],…
-
What do you use for your Sheet Reference Name?
Do you use the standard {Sheet Name - Column Name} ? Or do use a simple name that can be easily identified? Or Do you use abbreviations? Im curious and would like to know your approach, Im hoping I could learn a lot from your experience.
-
Need help with date reporting formula
I have 4 formulas in seperate cells that look at open and closed actions and does a count of how many there are for those months. The current formula for the current month:- =COUNTIFS({Date opened}, >=DATE(YEAR(TODAY()), MONTH(TODAY()), 1), {Date opened}, <DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1)) works fine and has done…
-
Help Needed
Hi All, I am trying to create a formula to work out the number of days ( Helper V1 ) between the VISIT 1 and VISIT 2 days column. Any thoughts would be greatly appreciated Thanks
-
INDEX formula to get the text in the next row in a different column
I need the formula to get the text from the next row in a specified column. I am creating the formula in row 2 in a column named 'Next' and want it to bring back the data from column 'Test' in row 3. This is what I have tried so far but getting #unparseable error. =INDEX(Test:Test, row() , +1) =INDEX([Test]:[Test], row() ,…