Hi Everyone, I am trying to filter out tasks on my Gantt chart occurring over the next three weeks. We found a good combination of filters that works for reports, however I want to be able to create a…
Hello All, Is there a formula to automate hierarchy? I am trying to use Smartsheet to create a family tree and dashboard. I have created a column labeled "Generation Tier" and I am using the people/pe…
Hello, I am trying to create a report view of my company's work schedule that only shows tasks happening over the next 3 weeks. I have tried using a combination of filtering by start and end dates in …
I have a sheet where new rows are automatically added to the bottom of the sheet from a form. I want the newly added rows to have formulas added to them, which I can accomplish using the Column Formul…
Hello! I am somewhat of a regular Smartsheet user and I have never had an issue with the IF formula but for some reason my new sheet I cant get the formula to work. I keep getting a #UNPARSEABLE error…
I'm trying to create a construction work estimate document that automatically populates a client's name, address, customer number, date, etc. at the top of the document. The document itself contains d…
I have to count how many cells contain a certain value, and have occurred in the last year. Example: Count of all closed projects within the last year Project 1 Closed 1/2/23 Project 2 Closed 1/2/21 P…
I am trying to write a formula that will enter the date when a checkbox is checked. I have an automation set up but it needs to be updated every month so I thought I could write a simple formula to en…
Hi All, I am trying to count how many offices have certain engagements (choices are Calls, Email, Weekly PF call, FB gorup, Other, Texts). These cells are linked cells from another sheet. I tried thes…