-
Adding cells with IFERROR blanks
I'm having an issue with this sheet: Smartsheet - Quote The COST / PC column is where the issue is happening. On line 4, I'm testing out using a different material that doesn't conform exactly to the sheet's setup but I'm trying to build in functionality to make it possible. When the columns being added by COST / PC are…
-
Sum cells from a reference sheet based on a range of dates
I need this formula to sum cells in a reference sheet based on dates. The reference sheet has a column with dates, and there could be multiple of the same date. I was able to get this formula to work on the top line in the screenshot, but the next line is adding the 2 week ending sums together. The planned bushels for week…
-
AI Text and Summaries Column Formula
Hey All, I submitted this product enhancement request through a feedback request a while back but I think this idea has a lot of merit and would really benefit the community as a whole. If you are like me, I'm sure you are all using and loving the AI feature! One thing that has been cumbersome about it has been that in…
-
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].…