Hello, I have several sheets. One every month with at least 2000 rows per month. I import the information from an outside source via Excel. Long story short, there is a high probably ability of gettin…
I have 3 fields. 2 fields are checkboxes and 1 is text. Active (checkbox) Not Active (checkbox) Complete (Yes/No) I want to write a nested IF statement that if either are checked it provides a Yes / N…
Everyone in our company is unable to access a file that we have created ourselves. The attached error asks that we Request Access but no one is getting an email. Is there something else I can try? It …
Each time a row is added (which is requiring an approval) i need the sheet to export the new data, to either an excel spreadsheet or google doc and upload to a secure site. The other option would be t…
Hello, I am having issues exporting a list of all my contacts within a specific group. Under the group management tab, there is no good way to export a list of everyone within a specific group. Anyone…
Hello! I've had a notification set up since March that sends to 2 other people besides me whenever I add or change anything in my Smartsheet. It worked beautifully until July 4th. I've changed nothing…
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into…
I am trying to automate a rent increase on a certain date. I have a table with Tenant ID, Rent Increase Date, New Rent amount. I would like to reference this in another sheet, so that when the rent in…
Here is my IF formula: =IF([% Complete]3 = 0, "Red", IF([% Complete]3 = 1, "Green", "Yellow")) It works great for green and everything else not so much. What I want it to do is calculate based off of …
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 f…
