Formulas
Discussion List
- I have a sheet for all incidents in the company that was started in 2023 and now that we're in 2024 I need to update some formulas so it only pulls the data for the current year. Right now the formula…
- Thank you for taking my question. What is the format to create a formula that supports this scenario; A total count or sum based on a specific word in a cell in a sheet. For example, collect the total…
- I am trying to create a formula for a cell where it collects the percentage of all the % values in the parent rows below it. Not only the current parent rows, but also any new ones that are added. The…
- Hi, I'm looking to input a formula to a sheet which will count the number of "Open" residual risks that are also recognised as 16 and above. I already have a column for the number of Residual Risks sc…
- Dear Community Is this possible in Smartsheet? I just can't seem to return what I need! I've been playing with Join(Collect()) type statements but maybe I have overcomplicated it! Scenario and require…
- I am trying to get a formula to work with multiple options selected in the reference sheet. The reference sheet has a Unit column and multiple contact columns. The contact columns are based off the ro…
- I have a column entitled 'RAID' with dropdown options: Risk, Action, Issue, Decision, and a column entitled 'Auto' which is a column type Auto Number starting at number 1 (no prefix or suffix). This S…
- Is it possible to have a report that pulls ONE task that is the oldest task (date-wise) that is not 100% for over 20 project plans? So this would be one report with 20 rows, all representing a differe…
- We have [column]@row. Why not =ROW()? I really need a column formula that returns the row number.
