-
HELP!!! Max Collect for Dates
I utilize Smarthsheet to manage a hospital schedule. I need to find out the last time a staff member worked. I have been playing around with Max Collect and constantly failing… #UNPARSEABLE Things to note: The Primary column shows the name of the staffer multiple times with multiple different dates under the Date Worked…
-
Edit Start, End, or Duration from Report
I'd like to be able to edit the Start Date, End Date, or Duration of a task from my report. At present I can only edit Start and Duration from a report because End is treated like a formula. This is problematic when I need to adjust both dates because it forces me or another user to do math (accounting for non-working…
-
Cross Sheet Index, Match, and IF
Hi, Thank you for coming to my help, I really hop this question makes sense. Basically, what I want to do is take the closest date of incomplete tasks and put it into another sheet where I can run automation asking someone to update a report. The reason I want to do it this way is because on the report you could be…
-
Showing multiple dates from the same sheet row in a calendar
I have 6 columns in my Smartsheet that are date columns, two of which are start and end dates. I have got the start and end dates to appear in a calendar report, but the other ones (individual dates, not date ranges) do not show up. I cannot have them as children rows. I have tried applying conditional formatting to the…
-
Task Health Indicator Formula (IF/AND/OR)
Got burnt out looking for my exact scenario in the forums, so looking for direct help. Trying to create a formula to automate my Health column KPIs based on task status and assigned dates. Status options: Not started, In Progress, Blocked, Complete Desired Status Colors Blue: Status = Complete Red: Status <> Complete AND…
-
How to Get a Balance Column to Show the Balance Remaining in Each Row
I am trying to create a budget sheet which shows the remaining balance for each line. Here are my columns: Order: This column has the following formula =MATCH([Row ID]@row, [Row ID]:[Row ID], 0) to allow me to move around items to better fit the budget balance for each period. Row ID: This is the auto-numbered smartsheet…
-
=COUNTIFS Metrics across 2 different sheets
Hi All, I have a metrics sheet where 4 of the 5 listed items reference 1 sheet and the last 1 references another sheet. I keep getting #UNPARSEABLE error for the 5th item. Below is my formula if anyone can help me figure out what is wrong that would be great! =COUNTIFS({Sheet - Continuous Improvement Sheet}{Project…
-
Summary Sheet Formula and Milestone / Key Task Gantt
Hello community, I am new to using the smartsheet so hoping you can help me with the below. How can I update this fomula that I am planning to use in my Summary Sheet so that it only includes count of tasks that has a start date of in the future. I want to exclude those from my count. I consolidated 3 projects into one…
-
Index Match Help
I can't seem to get this Index Match to pull all information its just pulling certain cells and I don't know why. I've tried VLOOKUP with the same results as well. Basically I have a sheet, Business Tracker, that tracks the names of Segments, the different levels of leaders, the FTE and call volumes numbers from their call…
-
Nested INDEX/MATCH formula for conditional cross-sheet reference use case
I am currently using the following INDEX/MATCH formula to return values from the sheet labeled "Tech Project List" in the reference. =INDEX({Summary from Tech Project List}, MATCH([Tech List Row ID]@row, {Project ID from Tech Project List}, 0)) I now want to expand that formula to include a condition: If #NO MATCH on Tech…
