-
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%…
-
DataMesh - Updating ONLY new lines
Hi - we get two-halves of requests from separate parties, and I'm using DataMesh to link to things based on a Unique ID. Once the second half of the request is in the sheet, I don't need to update it again. Right now, my DataMesh setup is updating that row anyway - is there any way to ignore "old" or existing requests?
-
Automated Workflow Not Working
I set up a simple workflow. Once someone writes their initials in a column, it should move the row to another sheet. Except it is not moving the row to the other sheet. But when I look at the activity logs from both sheets, it says that a row has been moved from the source sheet and the destination sheet says a row has…
