-
IF / CONTAINS using a range
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 Content Types: Data Sheet, Ordering Guide, BDM, TDM, Demo, Learning Map, Proposal Range 2 = 15 columns that contain a Product…
-
Summary Report - COUNTIF of multi-selection columns
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 below. What's happening here is I want to allow a COUNTIFS when a person is chosen, and count the number of instances data…
-
Nested if/then/and/or???
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 MUST be checked for all cases If none of the 'outside $$' boxes are checked and 'Check Cut to Vendor' is cut, then the…
-
Automated alert containing a form to contacts outside of contact list in a sheet
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 receiving an error message that some contacts (emails) are not being notified in my inbox. These contacts are not part of…
-
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?
-
Should I use IF or IF(AND....or Something Else?
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 a Yes response, however, when I tried adding in the other part, I received an error of either "Incorrect Argument Set" or…
-
When people fill out my form, It isn't updating my Smartsheet.
When someone fills out my form, the form will say there is a submission, but a new row is not created on the smartsheet. How do I fix this?
-
When saving as new, I want to break links including sumifs but I'm having an issue
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 Pivot will update monthly as new data is uploaded to the source report (I will also need the new data but the historical data…
-
New Admin Center - User Management
I like the update of the new "Admin Center" for controlling and editing users and groups, I accidentally clicked on the little graph with a down-arrow icon and got an email to download the user access data. It would be helpful to have a little tooltip for these, not only for the sake of our edification, but as part of the…
-
Chart budget vs actual
Hello, I have a sheet where I can see budget, actual and variance for my project budget. So column 1 is january budget, column 2 january actual and column 3 january variance, and so on. All I want to is to create a line-type chart for my dashboard where I can see the comparison between the budget and actual numbers for…