-
WBS numbering and work arounds
Good afternoon Smartsheeters ;) I am only new to Smartsheet and have started working on some existing docs. We have a very clunky and manual way of applying a designated PRIORITY number. When the sheet for each project/group of projects is first started, its easy - everything is labelled from 1,2,3,4,etc til the last row.…
-
Populate date fields per status changes
Hi, I am running into an issue with populating date fields per status change. I have two date fields that reflect per status change. For example: If status change to "option 1" change this date field to today's date. If status should change to option 2 change second date field to today's date. What I have currently:…
-
Finding Duplicates
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 getting duplicate information from the outside source. Once imported from Excel into Smartsheet is there a way to fnd & delete…
-
Nested IF statement with Checkbox
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 / No response. IF(ACTIVE = TRUE, "Yes", IF(OR(NOT ACTIVE = TRUE, "Yes", "No"))) I get the field to work how I want for Active…
-
Unable to Access File
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 is a document that has not been accessed in a few months. Would it be deleted after a certain period of time if that's the…
-
Automated export and Automatic upload
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 to do this based on frequency like nightly, but I guess the real question for me, and yes I am both new and green here, can…
-
Export User Group List
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 know how to make this happen? We have hundreds of users within one group and we want to pull that list. Thanks!
-
Notifications aren't being sent
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, but the notifications stopped sending. The last one any of us received was on July 3rd. Is anyone else having this issue?
-
Radar Charts
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 the Graph Types?
-
Automate a rent increase on certain date
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 increase date arrives, it will return the new rent amount. I can use the Index and Match to pull in the amount, just needing…
