-
Health column formula to automatically change based on due date
Hi all, Looking to get some help / formulas to help me with my sheet. I would like my health column to change colours automatically based on: Green = Status column marked completed Yellow = due date two days away from today Red = Due date in the past
-
Text to Columns: Getting rid of letters in between numbers
Hello, I have this date in this form 2022-08-21T02:04:38Z and I am trying to get rid of the letters 'T' and 'Z' in the middle of the date. Thanks.
-
Days Remaining until Due Date (minus weekends)
I have a countdown to the due date column, but right now it includes weekends. I would like to have business days only. My original formula was: The formula I thought would work was this, but got a #invalid data type error: Any suggestions? Thank you!
-
Contact List Column auto-populating with org emails
Hey there - new(ish) to Smartsheet and in a bit of a pickle. I have a sheet with a Contact List column that I use to request updates from outside partners. However, when the update request is sent the Contact List column field (where they could update their contact email) features a drop-down of emails for all users in the…
-
SUMIF Formula with Checkbox Criteria
Hello, I used to be able to use a sumif formula and pull in lines values that had a check box in one reference column or not checked in another reference column, and now that formula I used in the past doesn't work, I would use ...,{column Reference}, TRUE... ...,{column Reference}, FALSE... I can get around the issue with…
-
Formula to calculate the Next [Future] date in a string of dates
Hello, I'm looking for a way to find the next task due date. Ideally, I'll be able to look at a row with several date columns, and determine the next date. This would be the MIN Date that is Greater than Today's date. I can easily get the MIN Date, However, many columns are in the past. I want the next [future] date after…
-
Can't add a column to a sheet
I have the paid version (for years) of Smartsheet. For some reason on one of my sheets, I cannot add a column. Any help? Thanks! Jennifer
-
What are some practical uses for Duplicating a Reference?
-
VLookup #No Match Error
I am looking for guidance for the utilization of the VLookup formula. I have formatted this formula within one of my Smartsheet sheets and I keep getting the #No Match error message, I have verified this information already: 1) Range to retrieve data from is 3 columns wide by about 1000 lines long, so I don't believe that…
-
Option to include Children rows in Filtered results
I maintain master lists of initiatives in one sheet for each program I'm tracking but not managing. When conducting reviews, I filter the list of initiatives based the stakeholders I am meeting with. Most often, the Children of row item that matches the filter criteria are needed for discussion during my reviews. I…
