-
RYG formula based on start/end date columns
Hello, I'm looking to accomplish the following and am hopeful that someone will be able to help support. Thank you in advance. I have a Live, Start Date and End Date column. What I am proposing to accomplish: Live = Red, if the Start Date/End Date are in the past (*Sale has expired) Live = Green if Start Date is today's…
-
Automation with Time selection
Is there a way to allow a user without access to the smartsheet to select a time and date? We use the automation to send emails out to contractors so that they can give us a work start date. However, we also want to know the exact time of day that they can come out and do the work. Or is there a way to format a column to…
-
Calculating Average Work Days with Stipulations
Hello, I'm trying to calculate average work days that each command takes to return a request. However, it has to meet several other stipulations. -"Type of Request" has to include "FOIA" (drop-down column multi-select) -"Date Forwarded to Command #1" (in the formula it's "Date Fwd to C#1") is a date-only select, that…
-
I cant get the TODAY function to work in this script.
=COUNTIFS({Quality Inspection System (Failures) Range 2}, "01-05204", {Date}, >=TODAY(-90), {Date}, <TODAY()) I am new to writing scripts and am kind of stumbling about. I have used the TODAY function once on another sheet and it worked. I have tried the Smartsheet formulas examples page without any luck.
-
Automatic ticket numbering by location
Hello. I worked with someone on a previous discussion, but for some reason cannot locate it now. I have one data base file with the work orders from many different community locations. I wanted a solution for the Work Order Number to be a combination of the community abbreviation, the year, and then the number of work…
-
Help with an IF/AND/OR formula
Hello, I am trying to write a formula to return today's date when all of the following are met: Column 1 is not blank Column 2 is not blank Column 3 is either Kangaroo or Platypus If any of these is untrue, then I would like the cell to remain blank. Here is my attempt which returns an incorrect argument error:…
-
Launch manual refresment of all linked sheet and cells
Hi, I would like to know if there is a way to launch the smartsheet refreshment. I explain: I made many sheets with many cells linked together with formulas like Vlook up. When I change the searching criteria (for example a name include in a dropdownlist). I was expected that all formulas was update instantaneously but I…
-
Issues when opening a sheet
Hi, In certain sheets, where many conditional formatting rules, workflows and functions are set, every time I open the sheet it colors all rows in red and it offers me the option to save my changes although nothing has changed in the sheet. I believe this may be the cause for the activity log to record changes that were…
-
CountIF with dynamic criterion
Hi i'm trying to count the number of rows in a Smartsheet where the name in the "Engineer" column is the same name in the "Approved By" column I can get it to work by looking at a single row =IF(Engineer4 = [Approved By]4, COUNT(Engineer4)) but seem to look at all the rows in both columns and count the rows that match, is…
-
Auto refresh dropdown list
Is it possible to link dropdown list choice to a specific column in a specific sheet? That would be really helpful to update automatically the dropdown list. Thanks for your support
