-
Conditional Formatting
Hi all, and thanks in advance. I was trying to do a Conditional Format on this. I know how to do it in Excel, as I would use a formula, but I am having trouble with only the dropdown choices available. Okay, I want my CF to check if the 2 circled columns are the same. This instance does not show, however basically I amā¦
-
How to pull one column of data from one sheet to another and be placed in the corresponding box?
Hello, I have one sheet where information is collected for candidates we are looking to hire, and I need a specific column from another sheet of information to feed over to the candidate sheet in the column. The results that are fed over, must align with the correct candidate. Pictures below for reference. I triedā¦
-
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ā¦