-
System Field: Date/TimeStamp behaviour
Hi all, Have been a fan and avid user of SmartSheet since 2015. Great to see all the continual roll out of new capabilities / functionality. I am currently working on building a triggered notification on SmartSheet -- essentially, if a specific row has not been updated for "x" days, it will fire a notification to a…
-
UK Contact - Issue with account
Hi, does anyone have a contact number in the UK that works? my account & my whole company is locked out & asked to upgrade when we already have.... this is very urgent!!!
-
Formula to count rows in a date range across columns and status
I am getting suck trying to create a =COUNTIF formula from a sheet that has my date column, and several other qualifying status columns.Any advise would be greatly appreciated. Here is where I am at so far and I am getting an #INVALID Data Type error. =COUNTIFS({Sheet1 Range 3}, AND(@cell <= TODAY(), @cell > TODAY(-30),…
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
Autofill based on the new entry in another sheet
I run constantly to the same problem and decided to shout out for help. Basically my problem can be defined as cross sheets conditional autofill. My case: Sheet 1 (offers) - sales people add data about new offers with the web form (that's OK) Sheet 2 (orders) - I need to bring data from the sheet 1, if offer's status is…
-
Automate Formula Criterion
I'm sorry if the answer to my question is available. I could not find information about automating a scheduled update criterion included in a formula. For a monthly dashboard, I created a series of formulas to count the number of topics at various development stages, total days in each stage, and the cycle time between…
-
Using Countif and And together?
I am looking for some help on this one. I need to be able to find duplicates but only under specific conditions. For example, I have a list of SKUs as one column, and a second of the order status of that item. I need to know when multiple of the same SKU are in the same step of the process. So, instead of…
-
Nesting SUBSTITUTE functions
Hello All, I need help!!! I am trying to write a formula that replaces the letter "a" with the number "1", "b" with "2", "c" with "3", etc.... The individual formula of (ex.) =SUBSTITUTE([Column3]1, "a", "1") is easy enough, but for whatever reason I can't seem to figure out how to nest it with the rest of the letters and…
-
Attach File
I am trying to attache a pdf file that is 1.43 MB. (max file size is 256 MB) I tried with explorer and chrome. The far right hand of the row shows a green circle with a pie sliver which eventually disappears. The end result is no file gets loaded.
-
Editing Labels on Charts
Is it just me or are we not able to edit the chart labels anymore? They just brought out a bunch of a new charts and I can't seem to format word/number like I used to.
