Best Of
Why can't I add a new user to my account as a guest or viewer?
I do not want to add all new users to the account as 'Members'. I see no justification for Smartsheet making the new user default 'member' other than greed. To make this even more frustrating, I am unable to change the user-level until AFTER THEY HAVE ACCEPTED THE SMARTSHEET invitation email! Please stop frustrating your dedicated users.
tzaczyk
Re: How to Add and Equate for an Empty Field?
Does it work if you plug this in?
=IF(OR([Helper 1]@row = "1", [Helper 2]@row = "1", [Helper 3]@row = "1", [Hr 1]@row = "1"), "Fail", "Pass")
Paul Newcome
Re: How to add card and calendar view on Dashboard
Any update on this? It doesn't make sense to me that there's no calendar-view widget for the dashboard to begin with, but not having any options to customize the published/embedded calendar doesn't make sense either. I just want to display the calendar on my dashboard, and not give people the option to flip through different views of my sheet.
Laura Chow
Re: Does a workflow in a Data Shuttle have the ability to pull an updated report in a SharePoint Folder?
Data Shuttle looks for a file by name in OneDrive. What I would do is use Power Automate to stage the file for Smartsheet to pick up, and then either delete it or overwrite it with the new file the next week. As long as Data Shuttle runs once a week, and the file is there and has the same name each time, Data Shuttle will pick it up.
James Keuning
Re: Index formula help with a global update when referencing template metadata sheet
Hi @Jef Forward
Unfortunately, Global Updates in the Control Center doesn't currently support updating/modifying formulas with cross-sheet references. The INDEX formula needs manual adjustments for already provisioned projects.
There is a product feature request discussion on this.
To automate this, you can use the Smartsheet API to create cross-sheet references that dynamically adjust formulas based on the project context. This would require custom scripting. If you are unfamiliar with programming, Bridge is an alternative solution to help automate some of these processes without deep technical expertise.
Re: Maps & Hyperlinks
I know this is kind of sloppy but after days of searching, thanks to cbsarge I was able to take what he posted and figure out how to adapt it to my own sheet to make it work.
my sheet looks like this. I need to be able to map the address in the JOB ADDRESS column so my formulua for Map it column is
="https://www.google.com/maps/search/?api=1&query=" + SUBSTITUTE([Job Address]@row , " ", "+")
Buildermen
Re: July Question of the Month - Join the conversation and receive a badge
This year, my goal was to run four 5k races and train for a 1/2 marathon. Welp, a knee injury has canceled that goal. I've replaced it with developing my knowledge. :) I've started reading the 12th edition of USALI to understand hotel finance and working with a mentor towards PMP. Either way - I'm still building muscles 🤭
Darla Brown
Re: Fetching comments from a Smartsheet : Getting Error
I got it now Thank you so much help, Sheed ID was the part where I got confused, Now everthing is working fine
Thank you everyone who took their valuable time and responded back 🤗
Manik Salaria
RICEFW Template with Dashboard
Hello! I am looking to see if anyone has developed a RICEFW (Reports, Interfaces, Conversions, Enhancements, Forms an Workflows) Template with a support intake form and Dashboard?
Christen
Re: Bridge: Copy partial Row example - error
Try this for the Row ID in the Get Row module:
{{runtime.event.rowId}}
Notice the end is "Id" with a lowercase "d". It is case sensitive but understandably frustrating when the "sheetID" is a capital "D". I always suggest going into the run-log and copying the reference from there to help avoid this.
Paul Newcome