-
if/and/or formula help
I have a set of training records data. Some have required due dates, some do not. I need a formula that set s flag (for items needing attention) if: the complete date is blank the complete date is > the due date (if there is a due date) for this condition, i need it to ignore if the due date is blank When I use this…
-
Index/Match Formula Referencing Contact Columns Providing Wrong Values
I need help with a formula. Since there is no way to cross-check against a group in a sheet, I have created a sheet listing all users of a particular group and am trying to use a cross-sheet reference formula in my intake sheet to be able to identify when a requestor is not already in the group so that I can add them for…
-
If Project name column CONTAINS specific text
Okay I have 2 columns, one contains a unique number (left) and on the right that unique number is listed with the program. I have been able to accomplish this so far, however I ran into a little snag. There are some programs that contain JNEEO, and their unique TDL #. However, once I added the formula I discovered not all…
-
Return multiple values from one search criteria
Hi! I'm fairly new to Smartsheet formulas and have reviewed the community posts trying to find help to my question. I am trying to pull PTO requests from one sheet to another. VLOOKUP has always been a friend, but unfortunately does not pull multiple values. My lookup criteria is a single date, (ex 2/28/24) but there can…
-
A way to place the Row ID (for APIs) into a cell value with formula?
For clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to which records there might need a resulting update, to be done via automation, that would…
-
Time formula
Can anyone assist with writing a formula using military hours? See example sheet fields below.
-
automatically apply =Min/Max of descendants formula to parent rows based on hierarchy number?
is there a way to make those 4 date columns automatically apply the min/max formula once hierarchy is changed to 2? converting to a column formula does not let me edit the white/blank hierarchy date columns. and i tried doing an automation workflow to change a cell value, and the date columns are not options (they are NOT…
-
auto-populate date formula when column is checked
Hi All! I am looking for a way to add the date to a column when a check is placed in another column. I would want the date the check mark was added to the column. Any advice for the formula? Thanks kindly!
-
Display values from a row when a value in that row is a specific value
I am trying to create a reporting dashboard that displays elements of a row when a value in that row is "Yes". For example, if a workstream is blocked, the reference cell is "Is Blocked?" and if the value is "yes", I would like to display on the report the details of the workstream, the owner, and the reason it is blocked.…
-
Best practice to notify/ask if someone's name is selected from a drop down?
Greetings- I'm trying to figure out if the way I am doing it is the most streamlined way. I have a column called assigned staff where someone can select a single individual or multiple staff members. Once selected they are emailed with info from the grid asking if they are free during form submitted time (ex meeting time).…