-
How do I set an alert to trigger when Task A's date exceeds Task B's date?
Task A (prep is scheduled to be complete): date dependent on previous rows, will change based those Task B (prep is DUE to be complete): fixed date I would like to create an alert that will trigger if Task A's date exceeds Task B's date, but I am having trouble selecting the right conditions. I would also be open to…
-
Tasks not started
i'm trying to calculate the number of tasks not started (out of the box functionality for the accelerator that I had to repair) I'm trying to look at those that are tasks (so non-tasks are not checked), Percent complete is 0, and that have a task associated with them (so we aren't counting blanks). -Project Schedule Range…
-
Formula for connecting Checkbox columns with Health column
I am looking to connect both Checkbox columns with the Health column. These are the formulas I am looking for. If Nothing is checked off, Health = Red If SO Submitted = checked, Health = Yellow If Done = checked, Health = Green
-
Automatically Populate with the Date
On our project Master Sheet, we have a project status column. When the project status changes to "On Hold", I want the "Date on Hold" column to automatically register the date the project status changes to "On Hold. The current formula I am using is: =IF(["ON HOLD" Stage]1 = "Yes", TODAY()). It will populate today's date -…
-
IF formula giving me #INCORRECT ARGUMENT
I am using this formula to set status' in my sheet. =IF(ISBLANK(Cost4), "Request Submitted", "Request Reviewed/Priced", IF(CONTAINS("Approve", [CEO Approval]4), "CEO Approved")) I am getting an #INCORRECT ARGUMENT error. What am I doing wrong?
-
Ideas on how to strip file extensions from a file name?
Let me explain my scenario: User posts a document to SharePoint Via Power Automate, Smartsheet is notified that that document has been posted in SharePoint. This notification contains the full file name from SharePoint (including .docx, .xlsx, .txt, .jpg, whatever file extension). In order to associate this event to the…
-
AverageIF
I am trying to get the average number of days to fill a position, the formula I am using is pulling data from my worksheet for the Position type, date range, and days to fill. With my formula below I am getting an Incorrect Argument. I think it has to do with the bolded portion of the formula. =AVERAGEIF({Time to Fill -…
-
Ability to automatically update end date on a row, after row is created based on create date
We are currently using a Form to submit requests for changes and would like to use logic to update the end date of a row after the form is submitted and based on the create date plus X number of days OR after a status is updated, if the end date is blank update the row based on X number of days. Is this type of function or…
-
Need a way to fix row id, so they do not move
Hi, Little background, I am using below formula to get the row id in RowID column =COUNTIFS($Name$1:Name@row, OR(@cell = "", @cell <> "")) Now whenever I sort my sheet on the basis of date, the row ids also changes because the absolute reference changes. I am fine with sorting but I want the Row ID to always start with 1…
-
Red Yellow Green Gray
Hi Experts :), I need help with my formula. Principles I am trying to achieve are: if Min Variance column is blank AND the Minister Due Date is past today by less than 2 days, OR the Min Variance@row is Less than 2, then flag Yellow. If the Min Variance column is blank, AND the Minister Due Date is past today by more than…