-
Keep Workspace/Folder Structure when Bulk Transferring Sheet Owner
How can I get sheets to remain in the workspace/folder when bulk transferring a user's sheets to someone else?
-
Automation: Request an update but my contacts are not in a contact column
How can I work around this issue. My sheet is populating the "Contacts" via formula. I want to trigger automated update requests but am running into issues since I'm unable to convert the column type to "contact" since it appears that Smartsheet doesn't allow this functionality. Anyone have any ideas how I can work around…
-
Formula return blank result
I've attempted multiple times to create a function that result in Blue, Yellow, Green, Red health and it has been unsuccessful. Here are the results that I am aiming at: On Track > "Complete" "In Progress" = Green Ahead > "Complete" = Green Ahead > "In Progress" = Blue At Risk > "Not Started" "In Progress" = Red Behind >…
-
How to create a future date based on a date in another column?
Hi, I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days. Thanks! Keren
-
COUNTIFS formula using dates excluding weekend days
I'm trying to figure out the correct formula for counting up the # of entries for a particular location with a "YES" or "NO" data entry for the previous date, TODAY (-1), that doesn't include weekends. For instance, if today=Monday, then the formula would need to search for the previous Friday date and count the # of…
-
calendar and linked registrations
Has anybody used SmartSheet to mass distribute a calendar with multiple events shown and connected independent links so people can select and register for each of the separate events?
-
Website Counter
Is there a way to add a counter to the Smartsheet Dashboard to count the number of times the dashboard has been viewed?
-
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…
-
Please Share Your Thoughts About This Community
Hello Community! Later this year, we’ll make improvements to the Smartsheet Community experience to make it easier to find and share information. Some of the planned features include subject-specific forums, better search and filtering, and the ability for people to identify that a reply answered their question, just to…
-
How can I take a concatenated string and feed it into a form as an option?
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 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
