Formulas
Discussion List
- I have a worksheet that has parent child relationships. I have created a couple of 'helper' rows ('HELP-Phase' and 'HELP-Phase 1') to aid areport in illustrating the parent child relationships (i.e., …
- When a deal in my pipedrive reaches a new stage 'Job Scheduled' it automatically adds a new row to Smart Sheets with a Task Name and Duration. What I need Smartsheets to do next is automatically enter…
- I am looking to extract the string of data to the right of the LAST "/". Here is my formula =RIGHT([HELP-Phase]@row, FIND(" / ", [HELP-Phase]@row)) HELP-Phase cell contains the below; Project Platform…
- Hi All, I'm building a database of products and would like to automatically populate different data when a specific product is chosen from a drop-down column. For example: Column A > Product Column: S…
- Attempting to update a status column to show either Not Started, In Progress, or Complete based on blank or not blank statements from other columns. These formulas work by them selves. =IF(COLUMN1@row…
- I am using a sumifs formula with the same criteria to total 15 columns on my sheet. How do I carry this formula to other columns to maintain the criteria and sum up the total of the column it was carr…
- I'm trying to get an income by multiplying quantity with Price. Price is located on another sheet so I have to find it based on type, route, and active date. Here's the formula that I have: =IFERROR([…
- Hello, I have tried many different formulas and even tried combining formulas but can't seem to get one that works in a way for syntax to be used as a column formula. Any help would be appreciated, an…
- I am working on creating an IF(ISBLANK({cross sheet reference of column}), " ", Index(Collect({ NAME},{cross sheet Helper column}, helpercolumn@row,{cross sheet status}, "Status, {CrossSheetDate}, Con…
- I have a sheet that lists job openings. There is a column formula that assigns a "status" for each job by searching another sheet of applications. For example, if a job has 3 associates applications, …
