-
IF CONTAINS Help!
Good morning, I want to return specific values in a cell based on a drop-down list (single values per column), for example, if Activity = Marketing, then return value 45. However I need multiple options in each column, so I need the formula to then look for another activity and return a different value based on that.…
-
Smartsheet Behaviours
I am trying to create a form that throws back a response when you tick a box like the example below. I have been told to use the logic but i cant seem to find a logic that will work, any suggestions? Additionally, if they tick an answer and it is incorrect, I want to show the text in red and if correct the text is in…
-
Help with a formula
Could anyone help with a formula? I want to be able to calculate a total based on a column row. If the number is less than 100 it should calculate @ 50 cents, if between 100 and 299 it should calculate @ 75 cents and anything over is calculated at $1. My formula is coming up with unparseable =IF(AND([Total…
-
Only want certain columns displayed when entering information
I have created a sheet in Smartsheet with various columns with some having drop downs. When a drop down is selected "Novation" for example I only want to see certain columns that have "Novation" in the title for the user to populate. I hope that makes sense, please note this needs to be a sheet and not a form. Thanks in…
-
=COUNT({Approval Status}) prevent reporting lines
Hi All I am using on of the templates cost tracking. On one of the intake submitted sheets it has 2 lines saying <<Do Not Delete>> This is fine although it is showing up on the cost metrics as 2 submitted jobs, is there a way to prevent this or do i delete the lines that say <<Do Not Delete>>?
-
Can I use groups to create series?
I have this report and from this I have created this Chart but I want it to drill down to the show the individual Branches on a stacked column chart like this. is this at all possible?
-
Auto Populate a date if another cell contains specific text
So I am sure this has been asked, but i cant seem to find anything on this topic. I am looking for a formula that will auto populate a cell with a date if another cell within that same sheet contains specific text. Example: If [Assignment]@row, HAS "Audit", then place a date in [Audit Due]@row Searching for Specific Text…
-
"If Match" formula
Need help with an "If Match" formula to search for if a cell at row is on a list and return a check to another column
-
Including a comma for currency within an existing formula
There are two columns with formulas that I am looking to incorporate adding not only a dollar sign ($) but also a comma (,) to properly represent US currency. The LVL or Level column represents a current level. Each level has a different threshold requirement that must be met for both Current LO MRR$ and Progress to LO…
-
AVERAGEIF keeps returning "#Invalid Value"
I am creating Sheet Summary fields which count and average various values based on criteria. In one cell, a formula that works is =COUNTIFS(Manager:Manager, HAS(@cell, "Tony"), [Complete Tasks]:[Complete Tasks], "1") / ([Last Week Helper Column]1 + 1) For the record, Manager is a Contacts Column. However, when I try a…
