-
How can I count the amount of actions in a certain weekday?
Hi all! I'm trying to setup a formula that allows me to count actions (in red) and that also shows me the weekday in which they were made. The columns I'm using for this are 'S' and 'Action Creation Date'. My formula is currently the following: =COUNTIFS(S:S, "Red", [Action Creation Date]:[Action Creation Date], [Action…
-
COUNTIFS function with two criteria
Hi all! I'm currently trying to count how many red entries (in the "Puri Safety" column) are in the month of June (using the "Created" column). I'm trying to use the following formula: =COUNTIFS(Created:Created, IFERROR(MONTH(@cell), 0) = 6, [Puri Safety]:[Puri Safety], "Red") However, it returns a value of zero... what…
-
Feature Request: Smartsheet Desktop apps (specifically for Mac!)
Dear Smartsheet Team, PLEASE build desktop apps so that users don't have to rely on their browser to use Smartsheet. If you look at most people's browser, chances are they have a million tabs opened. That makes it easy for Smartsheet tabs to get lost in the chaos, which in turn reduces overall productivity and prevents…
-
I just deleted Columns in a Smartsheet and I have no backup
I thought I was in a Report. BUT I was in a filter and I deleted several columns from a sheet. I do not have a backup. In the recent history it will not show the data in the columns either. HELP!
-
How can I count dates in the past/future?
Hi, I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones are in the future and which ones are in the past. In this case, the counter should return 2 dates in the past and 1 date in…
-
Use Wildcards in an INDEX MATCH formula
Hi everyone, I need to use INDEX MATCH formula to get a DS# with a CNDT# in another report. The easy formula would be: =INDEX({DS Report Range 2}, MATCH([CNDT Number]1, {DS Report Range 3}, 0)), "") but the thing is that sometimes there are more than one CNDT#'s in a single cell. Since INDEX MATCH looks for the exact match…
-
How can I count the amount of actions in one specific month?
Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month (May), I want the counter to return "5". I've been trying to use the formula below but all I get in return is a zero: =COUNTIFS([Target Due Date]:[Target Due Date], IFERROR(MONTH([Target Due Date]1),…
-
Counting amount of actions in one month
Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month, I want the counter to return "5". I've been trying to use the formula below but all I get in return is a zero: =COUNTIFS([Target Due Date]:[Target Due Date], IFERROR(MONTH([Target Due Date]1), 0) = 5)
-
How can I compare two date columns in an automated workflow?
Hi! I want to create an automated workflow which copies rows where two date columns are not equal to another sheet, how can I do this?
-
IF Function Condition - UNPARSEABLE
Hello, I have the following formula that does not seem to be working. =IF([Result]19<0,100%,IF((AND([Result]19>=100%,[Result]19<103%)),100%,IF((AND([Result]19>=103%,[Result]19<106%)),75%,IF((AND([Result]19>=106%,[Result]19<109%)),50%,IF((AND([Result]19>=109%,[Result]19<112%)),25%,IF([Result]19>=112%,0%,0)))))) For every 3%…
