-
#BLOCKED / Auto-Save Issue in Project Billing Forecast Report
We are still facing a critical #BLOCKED / Invalid Value issue in our Project Billing Forecast Report. 📌 Current behavior: In the underlying Sheets, formulas (e.g., Total Billed This Period, To Date Billed) initially show #BLOCKED/Invalid Value, then refresh to correct numbers. However, the Sheet does not auto-save this…
-
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…
-
formulas with percentage
I pulled in a number from another sheet, % Complete from Plan, that is a percent and want to subtract this from 100%. This is the formula I am using: But it renders #UNPARSEABLE
-
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…
-
Countifs calculation get wrong number
Hi, I use a metrics table to calculate how many items in CNPA summary table. I want to calculate how many "Basic information" in Request Items column in CNPA summary table. The formula I used in metric table is COUNTIFS({Request Items},"Basic Information(location, die size…)") It returns 80. However, there are only 71. How…
-
Metrics Pulling Help
Hi there! I have a submission sheet and a metrics sheet. I am attempting to create a formula on the metrics sheet pulling from the submission sheet. I have no trouble pulling counts, but averages are giving me some trouble.. I am able to pull the average based on 1 criteria, but no more than that. I am looking to average…
-
Attached photos to designated cell
The ability to take an attachment submitted in the form, and if it is a .jpeg or .png file to add it to a particular column or cell. =IF([attachment]@row = true, [Photo 1] @row )