Formulas
Discussion List
- Hello! I would like calculate the due date based on the date based on "Date Received" and "Type of Request". I have been doing this manually and it would be great to have some sort of automation by us…
- Hi there! I'm trying to generate a health symbol for a column in my sheet and have created the below. I've indicated that the row is a "symbol row" and have successfully gotten my formula to deliver t…
- Hi! I'm using smartsheets to manage my business's projects and I have an automation that triggers when my PO checkbox is ticked, so that it copies the project over to a separate client sheet. Necessar…
- Why does my formula show #UNPARSEABLE? =COUNTIFS({[Name] Initiative - RAID Log Status}, CONTAINS($[Column7]$120, @cell), {[Name] Initiative - RAID Log Action Owner}, CONTAINS(Input@row, @CELL)) $[Colu…
- I'm seeking health with a couple formulas to pull in employee names when they are nominated for a certain value. I have columns for: Name, Value, Region. On my metrics sheet, I'd like to capture: Name…
- I have a column with multiple values inside it with a line break delimiter. It is a result of a Join formula which looks at more than 100 columns to join them together (there's typically no more than …
- I include fiscal year on most of my sheets. Our fiscal year starts July 1, so I write a formula such as FY = if(Month(date)<7, Year(date), Year(date)+1). Would it be possible to create a FY formula in…
- If a cell is check marked "✓" then I want a cell next to it to show the value of another cell. Then I want all subsequent cells underneath to run a value of that cell plus the value of the previous ce…
- I'm trying to create a Gantt Chart on a document where the End Date field is a column formula; it being a formula is pretty much non-negotiable. The formula reports a date from the 'Requested Due Date…
- In an easy way to explain what i want to achieve: I have 3 smartsheet files: 1- Tops ( contains all tops with price) 2 - Bottoms ( contains all bottoms with price) 3 - Master Sheet ( contains all tops…
