I have several sheets that take a doctoral student to unpack to figure out why they work and I'm hoping that Smartsheet has simplified so that I can pare back some of our formulas. One of the most com…
Hello! So I have a master sheet copied into 2 other sheets where people will make updates to in several row sections. I want the master sheet to reflect the averages of what they select in each row se…
Hi, I am having difficulty with my formulas referencing summary sheet cells. My goal is to indicate a date range in the summary sheet cells, input a customer, and have it a summary cell show the sum o…
Hello all, I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My…
Hi community, I could use help with a formula. I have a sheet that has all of our Claims data (types, dates, etc) and then a separate sheet that identifies the different claim fees per type of claim. …
Hello, I'm having trouble with my formula and can't quite figure out how to fix it. =IF(AND([LookUp Value]10 = "Y", {April THD Tech on Call WK1} = 1), JOIN(COLLECT({April THD Tech on Call Name}, {Apri…
Hello! I am trying to figure out how I can autofill a column in a RAID Log sheet based on the project name entered in a cell in the Project Plan sheet. What I tried: First, in the RIAD Log I added a "…
Hi, I have custom contact list column, which displays email contacts based on the conditions. Here's an example of that column: =IF(AND([Column1]@row = "Value1", OR([Column2]@row = "Value2", [Column2]…
Hello, I am trying to write a formula that will calculate priorities as such: If Live Count = <15,000 return Critical to Priority column If Live Count = <10,000 return High to Priority column If Live …
I would like to automate a due date of 5 weeks from the creation date unless the status is “On Hold”. Then the date should be blank. When the status changes from “On Hold” to "Open" then the date can …
