-
Count Number of Days Past Due
Ultimate goal: Create a formula that will count the number of days an item is past due, while giving credit (by counting it as zero) for items completed early or on time all while ignoring where a due date may have an "N/A" or other issue in the field. This formula will then be used to create an average day past due…
-
Formula to populate a cell based on another cell's formula criteria
Hi Again, I have a formula in row 1 of column Project Status that identifies the last value in the column that has any status except Not Started: =INDEX(COLLECT([Project Status]:[Project Status], [Project Status]:[Project Status], <>"Not Started"), COUNTIF([Project Status]:[Project Status], <>"Not Started")) In the example…
-
I need a formula to create a Contract iD for 4 different org's that are listed in 1 column
I need to create a formula in a column that will in the end give me something like ATF021 or RDI231 or RD473 Each org, ATF, RDI and RD will have their own contract iD; so ATF021's next line item needs to be ATF022, 023. Then if the RDI org enters a line item, there contract iD will be RDI231, RDI232, RDI233 and so on. Same…
-
How do I pull the second name from a multiple-contact column?
In Smartsheet I have a contact column (Project Support) that can have up to three contacts (first name + last name), for example Jane Doe. I then have three other columns that pull the first contact, the second contact and the third contact. The first contact column is Project Support 1 and the formula is =LEFT([Project…
-
IF FORMULA FOR GOING-TO-EXPIRY EXPIRD-SOON EXPIRED AND VALID CERTIFICATE
My criteria are the following: If the Expiration Date Column cell is more then (60) days remaining = “Valid” If the Expiration Date Column cell is less then (60) days = “Going to Expiry” IF the Expiration Date Column cell is Less then (30) days = “Expired Soon” IF the Expiration Date Column cell is between (0) days to…
-
IF FORMULA FOR GOING-TO-EXPIRY EXPIRD-SOON EXPIRED AND VALID CERTIFICATE
My criteria are the following: If the Expiration Date Column cell is more then (60) days remaining = “Valid” If the Expiration Date Column cell is less then (60) days = “Going to Expiry” IF the Expiration Date Column cell is Less then (30) days = “Expired Soon” IF the Expiration Date Column cell is between (0) days to…
-
Return latest value from another column's latest rows
Hello, I have a sheet in Excel I'd like to move to smartsheet to work with a client's team. The only problem I have is with the fields "Previous Cumulative Partner Discount" and "New Cumulative Partner Discount" as they have formulas that involve each other column in theirs and in Smartsheet it returns the circular…
-
Copy / Move Row from one sheet to another with formula
It would be incredibly valuable to be able to copy a row from one sheet to another with formula remaining in tact. At present formula seem to copy and paste as plugged values.
-
How do I structure formulas so that I receive a specific count back regarding Task Status?
The Smartsheet above is referenced by multiple members of my organization, but I'd like to simplify some of the information for the members who only want to know specific metrics. I've obscured information that could be considered confidential. I'd like to write formulas that report back the following information: 1. The…
-
Help with IF formula - 3 options to return
Hello Smartsheet Community, I'm struggling with something that I guess should be a very simple formula. I need to assign one of 3 values to the row based on the following rules: If Cutoff Date > Event Date, return "Pre-" If Cutoff Date < Event Date AND Weeks Post Cutoff Date </=8, return "Post1" If Cutoff Date < Event Date…
