Hello all I'm a bit stumped by this and would like assistance on how to create my formulas. I'm tasked to create a sheet, view, or dashboard to summary our master data sheet turning it into a matrix s…
Hello Everyone! I am trying to create a formula that counts the number of times a condition is satisfied for each month/year. My sheet has a column "Parameter" that either has the value "OFF" or "ON".…
I have a sheet that tracks the priority level of funding requests and I am trying to formulate a metric that 1) counts the number of requests under a particular priority level and 2) only counts the r…
I have been trying with no success to create a formula to identify schedule conflicts if multiple people are assigned. The formula works fine with a single person assigned. For the test case, I am usi…
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…
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], [Pro…
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…
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, …
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 Expira…
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 Expira…
