-
How to link the health column to show an accurate status of at risk tasks.
Hi All, I am looking to find a way that I can link (create a formula) so the health column shows a traffic light system for the status of the task. I want to aim for this to detect the percentage of completion of a task in relation to the finish date. For example, if the finish date is only a couple of days out and the…
-
autofill of formulas is not working when adding more than one line of data without saving the sheet
I have a sheet with some formulas. If I add a new row of data ,the formulas are autofilled as expected. If I add another row of data, the formulas are not autofilled. If I save the sheet after adding the first row of data, the next new row will autofill the formulas. This means, I have to save the sheet after adding each…
-
Flag Item if cell is blank a the date is greater then 3 days
Hi, Not sure what I am doing, probably something really obvious, but I am trying to flag items that have a cell blank and the date that person was notified is more then 3 days from today. Could someone please assist? I greatly appreciate it! =IF(AND(ISBLANK([Approver (Type or Email)]@row, [Date Initial Email Sent to…
-
Flag at Risk column based on child rows summary
I have an "At Risk" column where the flag is triggered when a certain condition is met. Can anyone please suggest with a formula for each parent row in the at risk column such that if the child rows have more flags raised than blanks then the parent row cell needs to also be flagged up? So say if there are 6 child rows for…
-
Formula for delay between target and actual end date
Can anyone please breakdown and explain this schedule delta days formula that I have got from one of Smartsheets ready built template? I think in essence, it is trying to calculate the delay between the target end date and actual end date but because there are so many functions used in the formulate, it makes it a bit…
-
How can I use two conditions to return a specific result in another column
I am working on creating a form for stakeholders to complete that will populate a smartsheet that we've had in place for several months. This would create efficiencies for us and help our stakeholders as well. I want to be able to do the following: When a specific selection of department is made, and the spend amount is…
-
Formula to link all columns in multiple sheets
Hey, I have a master Smartsheet actions tracker set up with actions assigned to roughly 5 people across a project and each of the 5 personnel have their own action tracker linked to the master sheet. How it works is that any time a new task is added and the "Assigned To" value changes to an actionees name, through…
-
IF/AND formula based on a drop down column if the cell is blank
Hi All, I am working on a formula to trigger my at- risk flag based on the following information. Raise the flag if the end date column is less that 1 day away and the status column is blank or Not Started. Here is what I have so far. =IF(AND(Status3 = "Not Started", [End Date]3 <= TODAY(2)), 1)
-
I.T. Project Management workflow process
Hello, I am new to Smartsheet and have seen nearly all of the training videos, I work in I.T. Cybersecurity and wanted to get your opinion on how to create a Smartsheet(s) for looking at installation, failures, dates, etc. for I.T. disk drives. I have information on an excel sheet that was provided & an initial Smartsheet…
-
dropdown multi-select and lookups -- vlookup, join, collect, index, match???
Hello, I'm having trouble understanding what function I should use to do lookups when there is more than one matching value. I know how to use vlookup, at least well enough to know it won't work in this case. Here's what I'm trying to do: On one sheet (sheet1) I have a dropdown multi-select with about 80 different options.…