-
Include download URLS for row attachments
We are looking to include the URL to download a PDF that was generated through the document generator for the row. Any suggestions
-
IF Statement with IN list
Column A = Grid Task Status Column B = SCSM Task Status pseudo code: If column A = column B then "No Action Needed" If Column A in ("On Hold", "Awaiting External Resources", "In Progress", "Implementation", "Testing) AND Column B = "In Progress" then "No Action Needed" Otherwise "Review Needed"…
-
Formula for checking a checkbox when a row is updated within the last 4 days
Can you help create a formula that will check the "Agenda Updated" column when the modified by date is within 4 days of today?
-
Return value after matching across sheets
Hi SmartSheet Community! I need some help with a formula which will compare two values across sheets and then return a value stored in one sheet to the other if there is a match. This is what I currently have which may give some sense of what I am trying to do, but I don't quite know enough to get it right: =IF(AND([Bill…
-
Status stoplight ball formula
Hi all... I have a pretty good working formula to automate task status with stoplight balls based on percentage complete and how close we are to the task's finish date. I have it tied to a 7-day flag column that is flagged when we are within 7 days of finish or past finish date. The stoplight formula is: =IF(AND([7 Day…
-
COUNTIFS Using "OR"
Hello! I have two working formulas that counts my company's personnel based on specific criteria, but I'd like to use them in the same cell so that data is gathered if either of them are true. Here are the separate formulas: =COUNTIFS({NST2023Role}, "Sr. Dean", {NSTStatus}, "Invited", {Area FY23}, "East")…
-
Adding IF to a formula with IFERROR
I'm using the following formula (which works because you all helped me with it!) =IFERROR(NETDAYS([Date of Verbal Agreement]@row, TODAY()), "") I need to add "if the "Deployment Complete" box is unchecked but have no idea where to put it in the formula. Thanks for your help!
-
Cell linking from one cell to a column on a different sheet?
Is there a formula that updates sheet 2's column when I enter data on sheet 1's row? ex) If a daily update starts on sheet 1 when the data is entered/attachment is attached, can a date automatically enter on sheet 2's date column? Sheet 2 is a running sheet so the date that I want automatically entered would be put once in…
-
Countifs Function with Two Coulmns
I am trying to create a function where it will count the number with specified criteria in one column as well as if 1 of 2 columns is not blank. I have the formula figured out where it will count 1 of those columns but cannot figure out how to add the "OR" piece so it will count data from column 2 only if column 1 is…
-
IFERROR Formula getting an error
This formula is giving me an "Incorrect Argument" error. =IFERROR(NETDAYS([Date of Verbal Agreement]@row, TODAY(), "")) What am I missing? Thanks!
