Formulas
Discussion List
- 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, …
- Hi, I am trying to get a a person's region included in a sheet by matching their name in the Staff Column to the source sheet. However, when the row in the Staff Column is blank, I am getting a return…
- Hi All, I have a shipping tracker I created for six different stages we're doing for a project. I need to create a graphical representation of the different statuses for each stage and type. The formu…
- Hi All, I have column title named 'Type of Request' and you can click multiple answers, so a cell can contain 1 or maybe 4 answers for example... . I have another column called 'Date Created' which is…
- Sorry if this is an obvious question but I am new to Smartsheet and I am trying to get my head around Totals and Sub Totals. In our Project Plans we have 3 columns relating to Effort: Planned Effort T…
- I am trying to put a formula together to say if there is a date, list it here (On-Site Training), if it says no match, then don't do anything.
- Can a formula contain a reference to a checkbox cell and then return a result based on if that box is checked or unchecked?
- A component is adamant about tracking their actual time on projects based on percentage of an 8-hour workday, but senior managers want to see actuals based on hours. Is there a formula or other way fo…
- Using the formula below to pull references from two sheets. I am getting data returned from the first sheet, but not the second. When I reverse the order of the references the formula works the other …
