I have a master sheet that may have duplicated column data, like: Client Name | Status (dropdown) | Delivery Date | Feature (checkbox) Client A | Rescheduled | 2/5/2020 | 0 Client B | Postponed | 2/12…
I have two sheets. One with contact information and another with the fields for a form. I have a formulated column in the contact sheet that compares information to the form sheet and determines if th…
Have an issue I thought I had resolved, but ... I have a sheet that has two relevant data ranges: Range 1 = a single column that specifies a Content Type for each row item. There are 7 possible Conten…
I love the way a Summary Report can kinda be a poor man's pivot table within Smartsheet, and it works really well, up until you try to do conditional counts of columns with multiple selections. See be…
Hello out there, attaching a screenshot for reference. I'm trying to get the far right column ("Completely Processed") to check under a series of different circumstances: 'Check Cut to Vendor' box MUS…
Smartsheet Community, I am trying to create an automated workflow that will alert hypothetical meeting participants with an additional message containing a separate Smartsheet form link. However, I am…
Good afternoon everyone. I was hoping someone could help me with a formula I'm having an issue with I tried a few different equations. I found by removing one of the parts of the equation, I received …
I have a sheet that's linked into a pivot sheet via a series of sumif cross sheet formulae. This sheet is looking into the pivot sheet at a point in time e.g. month of April YTD information, and the P…