-
New entries to the Smartsheet don't include formulas
Hi all, New entries into my Smartsheet are not including the 2 formulas I have created. I have tried the troubleshooting which advised the following: Ensure the formulas are present in cells near where you want the new rows to appear. Check if the last row before the new entry is indented, and remove any unnecessary…
-
Formula for Resource Type, Resource Name and Year
Hello - We have set up a sheet to pull from a Master document to include Resource Type, Resource Name and Year. The Year is from a Helper column. Can someone review the current formula we have to identify where we went wrong to no pull "zero" as the result vs the actual number. Before adding in the Help Year and Reference,…
-
How can I make FS dependencies start on the same date the predecessor ends?
Hi everyone, I’m migrating a schedule from MS Project to Smartsheet and I noticed a difference in how FS (Finish-to-Start) dependencies behave. In MS Project, when a task has an FS predecessor, the successor’s start date is set to the same day the predecessor ends. But in Smartsheet, the successor is pushed to start one…
-
SUMIFS Unparseable Error
Hi, I'm attempting to use SUMIFS to sum data (Royalty Rate) from another sheet if the Project Number in the other sheet (Project Num) matches Project Number in the current sheet, and if Based on from the other sheet is "SRP". Current formula that isn't working is below. =SUMIFS({Royalty Rate}, {Project Num},[Project…
-
Comparing names from Worksheet A to Worksheet B and Identifying those on A that are missing from B
I have two worksheets. Worksheet A is the master Worksheet B is a collection of months' worth of data-it is populated by a form. I'm trying to write a formula where I compare Names from Worksheet A to Worksheet B and identify on Worksheet A names that are missing from B in the current month. Worksheet B has a column that…
-
Cross-reference sheets to find matches
Hi! I am trying to determine how many of our students are later hired by our institution. I have a Sheet with a Student Name column , and would like to add a "Hired" Column in this sheet that would cross reference to a second sheet (Master employee list) and flag if there is a match in the Employee Name column (so if a…
-
IF OR formula for 3 conditions
Team, Struggling to get the below formula to work…any thoughts. (The cells contain numbers in text/numbers columns): =IF(OR([02/01/25]@row < [01/01/25]@row , [02/01/25]@row <> [01/01/25]@row , [02/01/25]@row > [01/01/25]@row ), "Down", "Same", "Up") Thanks
-
Formula for Multiple same names count once AND single name counted as well
I used this formula from another community post which counts a person's name only once if it appears multiple times in the column. However, it does not count a person's name at all if the name only appears one time and I need it to. In the example below, how can I get it to count Doe, John as one AND Mouse, Mickey as one…
-
Formula for Tracking
Hi everyone, I'm struggling with creating a formula to track the progress for my project. So I have created status for each activitie which need to be done. However, I don't know how to link them and turn into % of completed progress. I will attach the image below. For example: When Venue Booking is Done. The % of…
-
Smartsheet Calendar unable to update health status on source sheet
Hi, I created a Smartsheet calendar organized by Phase and then Workstream, with deliverable bars spanning duration. The goal is to create an interactive Gantt chart, which team members can update tasks on the calendar detailed side panel. The formula on the source sheet states that if At Risk is checked then Health is…