-
Dashboard not updating
Hello Smartsheet Community! I created a formula that tracks the number of days away from the deadline that I posted on my dashboard as a visual for my students. =IF([Deadline Date]@row < TODAY(), "🔴 Past Due (" + ABS([Deadline Date]@row - TODAY()) + " days ago)", IF([Deadline Date]@row = TODAY(), "🟠 Due Today",…
-
OTIF
I am trying to calculate OTIF per month. I just added a Helper Column to identify Ontime and Late items. For example, would like to know Aug. 2025 On Time vs Sept. 2025 On Time. How can I achieve this?
-
Return a value based on 2 matching criteria, one of which is a dropdown menu.
I am working on a formula that will match a date from my reference sheet to my working sheet, and a word from a dropdown menu in a reference sheet and return the word "Completed". None of these work
-
Date Function Returning #INVALID COLUMN VALUE - even in clean new sheets
Hi all. I’m running into an issue that I can’t seem to resolve, even after a lot of testing. Hoping someone here might be able to help. Basically, any formula I use that involves a date function, like ISDATE() or TODAY(), is returning #INVALID COLUMN VALUE — even in completely new, empty sheets. Here’s what I’ve tested so…
-
Issues with Attachments
Ok, I'm not new to Smartsheet but recently this simple automation has had me stumped. Pictured below is a simple automation we use to verify that an attachment has been added to each row in our system. IF attachment added or changed, THEN Change Cell Value. These worked beautifully all over our system until about a month…
-
Formula Help - Phase identifying
Good morning :) I'm trying to figure a way that the row is labeled by the phase of the project that the line is in without having to manually do it. Please see below expected output for 2 phases. I have also attached an excel sheet. I would greatly appreciate any help on this please.…
-
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
-
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
-
Match or Index
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
-
Calculate number of days between two dates in the same column on the same sheet
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…