Good afternoon from Spain. I faced an issue with WEEKNUMBER formula. 30th december is monday, 31th december is tuesday. If we calculate their weeknumber, the answer is '1'. This behavior is incorrect.…
Hello, What I first thought would be an easy formula has turned out to be quite a pain. I am trying to count the number of rows where one column matches the other. My formula returns #INVALID OPERATIO…
Hello, I am testing out the TIME() function and working on a formula to determine the amount of hours and minutes elapsed between a Start and Finish columns. I thought I had it figured out, however, I…
Excel has leapfrogged Smartsheet in terms of ability to utilize data set, naming manager, dynamic data slicing, Dynamic Table formatting in excel sheets and new formula types LET used with Naming Once…
Hi Smartsheet Team, I am looking for help with a formula: I have a column "Schedule Health" that has RYG Balls I am wanting this to change color based on certain criteria from 3 other columns "Status"…
Hi, I am using helper columns to overcome what I think is a major missing feature - the inability to use formulas for conditional formatting (for instance, if a date in one field is after a date in an…
I could've sworn I'd seen this but now I can't find it: We have a sheet for incoming project requests. Our general population can request multiple new mkt materials (printed direct mail, email, outloo…
Hi, new to Smartsheet but enjoying it so far. I'm building a report from multiple sheets that would ideally be a master list of all the rows that do not have a blank cell for one specific text/number …
Hi Smartsheet Community, Recently I've been working on a column that allows me to assign required approvals based on certain roles (see below). I want to create a formula that can output an role if it…
I was wondering if it is possible to create a formula that changes one cell to a date when another cell was modified: I have two columns I want affected: 1) Status, 2) Closed Date. When the status is …
