-
Formula Help - Open, Pending, At-Risk and Complete
Hello, I am looking to create a formula if a request is/was submitted I would like it to display open, pending, at-risk, or complete. I also need to exclude changes to that request if the status reflects canceled, rescheduled, no-show, or declined. Currently, I have a vlookup to display only the open or completed requests.…
-
Need a COUNTIF of "% Complete" cells that are either blank or less than 100%
I just can't figure this one out. Any help is appreciated.
-
Restrict duplicates in a dropdown single select column
Hello all! Does anybody know if SS has a way to restrict duplicates in a dropdown single select column? For example, "Project 4" is already using "D," so when I select a value for "Project 5," "D" would not be available since it's already in use. Or, if I select "D" for "Project 5" it would automatically change "Project 4"…
-
Fields Will NOT Add to Form After Completing Formula
I recently had a Pro Help desk call to figure out how to add a pre-populated field to a form. We got it working easily and I will paste the formula below (we added the Work Order ID field to the form because it tends to be filled out incorrectly). =FormLink?Work%20Order%20ID=" + [Work Order ID]@row I tried to write this…
-
AVERAGEIFS
I've looked through the community and think AVG(COLLECT) is the answer to needing two variables to match before averaging. I'm also referencing another sheet, which isn't an obstacle for me any more. I have a formula that works but need to add a 2nd variable. What I want to do is create a "calculator" that an office leader…
-
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…
