-
Incorrect field value in email with Smartsheet automation
Hi, I see an issue in automated email if we use a Date column with formulas. In my sheet, I have a Date type column (CreatedDateTime) with formula =Created@row+"". So, When a row is added, this cell shows the Date and time based on timezone selected in Account->Personal Settings. e.g. 06/23/21 6:27 PM I am in GMT+5:30…
-
What value does MATCH return if it matches nothing?
Or possibly my question is what is the null value in Smartsheet. And does it matter if the context is boolean or not? Thanks.
-
IF Formula assigning scores
Hello, I have a formula (below) that assigns scores depending on a criteria and whether or not the checkbox is checked. I.e. If the Governor's Dashboard is checked, it will assign 4 points to the total project score. I have one item that I no longer want to be a checkbox (bolded below). I would like "Do you have required…
-
Counting checkbox's for children without counting the parent
OK I am new to building formulas like this and everything I keep trying gives me errors like "UNPARSEABLE" and "BLOCKED". How would I set up a formula for this? If the "Is there a color image?" box then the row will be counted. My goal is to have a total count of images that we have a color version for. the URL is on a row…
-
How to use MATCH function on multiple columns at the same time?
I've used the MATCH function before on the "City" and "CityMATCH" column. It worked out well. This is the formula that I used: =MATCH(City1, CityMATCH:CityMATCH, 0). I've now added another column called "Number" and "NumberMATCH." What I want to know is whether "3" in the "Number" column and "Chicago" in the "City" column…
-
Summarizing items by country
Hi there - I am working on a dashboard and would like to summarize content created in a region and then by country. Right now I have this set up manually with a formula based a static list of countries, but I am hoping there is something I could do that would pull the country list automatically from the column, as new…
-
Automate Harvey Ball based on % of checked boxes
Hi Smarties, Having a bit of a problem with this challenge. I would like to automate the [Progress] Harvey Ball's based on the % of checked [Completed] boxes in the children rows. If 0-24% of boxes are checked, the harvey ball should be empty. If 25-49% of boxes are checked, the harvey ball should be one quarter full. If…
-
Alert when Checkbox Column gets Unchecked
I have a formula column that gets checked or unchecked depending on some other things in the sheet. An alert goes out when this gets unchecked (and when rows get changed, not added) on an hourly basis. We recently got an alert saying that a row got unchecked but it makes no sense. I checked the cell history, and it was…
-
Count a row if the date AND Member Number both do not match another row
I am trying to create a formula where it creates a 1 in a column where the date AND the Member Number both in one row do not match the date AND the Member Number in another row. For example, in this row, the date is 05/20/21 and the Member Number is 987654. If another row also had the date as 05/20/21 and the Member Number…
-
If/Then Statement to Return a specific date
Hello, I am new to Smartsheet and though I feel like this should be a simple formula, I am stumped. I am hoping to create an automation that would calculate a due date from a date received based on the value selected from a drop down list. So if I choose option a from a drop down list (Permit Type), then add 30 days to the…