Hello, I have a customer list and I am trying to use it to extract data from another sheet to get customer specific information. My SUMIFS formula to total the $$ for all projects with a specific cust…
Hi, I am trying to calculate % complete with an IF formula because if it is marked complete I want it to say 100% and the current formula is tell me it is 3,098% complete because start and end date ar…
Hello everyone, I hope you're doing well. I'm facing a difficulty in setting up automation. In the project model we've adopted, one person is responsible for monitoring the project progress, and this …
I have a check box that if checked I want my cell to be 0, but if it is not checked I would like it to sum up three other cells. What is wrong with my formula (Example #1)? I am also having an issue w…
I am trying to count how many items in a multi-select drop down column fit the criteria to accurately return the number. My main issues are that the multi select columns have multiple criteria that ne…
How do I set up a formula so that if([column A]@row="something", copy the value in [Column B]@row to [Column C]@row,""). I appreciate any help you can offer.
HI I am trying to calculate how much we have billed out, but not yet collected. We have 4 columns for each payment, up to 12 payments total. I want to add the Payment amounts together, only if Payment…
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…
