-
Problems automating and matching with formula
Hi, I have a formula that used to create an order number, composed from the following fields: The date date + an auto number, then the "/" character gets removed. Our vendor also uses Smartsheet. I have an automation set up to send the information over to the vendor, but it doesn't transfer right. It consistently transfers…
-
Question for Countif function
Hi There, I'd like to count the cells which year belongs to 2024, seems the formula I wrote cannot capture the correct volume, may I seek your help for it? which part is wrong in my formula? Details as following: My formula: Reference column: Thanks in advance!
-
Help to link health status formula to status
Hi, Need some help here is my current formula for health status in project plan. =IF([End Date]@row = "", "", IF([Summary Helper]@row = 1, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", ""))), IF(Status@row = "Complete", "Blue",…
-
Multi-row intake form
Hello , is there any way you can have multiple row entries in a single intake form?
-
Target Start/End Date
Ultimately, I need a good way to track if we are completing tasks on time based on our original estimates because we have users that estimate a task will take 5 days and when it takes 15 they just change the dates, and the project status still looks green, when is reality it is behind. I would like to have target start/end…
-
Tracking Which Reviewers Have Not Submitted Forms Across Multiple Sheets
Hi Smartsheet Community, I’m looking for some help setting up a way to track reviewer submissions across three different sheets. Here’s the setup: We have three sheets (one for faculty, one for students, and one for scholarships). Each sheet lists applicants, and in each row we assign three Selection Committee (SC) members…
-
Need a formula that returns a date while factoring in dependencies
I’m looking to add a couple of columns into my project plan sheets. SmartSheet already has a [Start] & a [Finish] column built into its project template, but I’m looking to differentiate between [Plan Start] & [Actual Start] and [Plan Finish] & [Actual Finish]. I renamed [Start] & [Finish] to [Plan Start] & [Plan Finish].…
-
Getting “Unparseable” error on nested IF/AND/OR formula with cross-sheet references
Hi everyone, I’m rebuilding an Operational Status formula that references another sheet for quarter-end deadlines. The formula works logically, but Smartsheet keeps returning #UNPARSEABLE. Here’s the current version (I’ve confirmed all range names and column types are correct): =IF( AND( OR([Step 1: CQ LAUNCH Required (Yes…
-
Row ID / Row link
I'm building simple asset tracking system with Smartsheet and would like to have the row links as QR-codes that would then be printed as asset tags. I have not been able to find a feasible solution for pulling the row links for each asset (row). Doing manual copy paste for >2000 rows is not very convenient. I have a column…
-
Based on frequency selected change the formula for the created date.
I feel like this should be super simple but I am just not getting it right. Based on Frequency: Daily, weekly, monthly I want to change the next due date This will be calulated from Created column and +1, 7, 30 etc added. It works single instance =IF(Frequency@row = "Daily", Created@row + 1) but as soon as I try to write…