Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Sorting in the Smartsheet Mobile App
Hello, I was wondering if the functionality for sorting was available on the Smartsheet mobile app. I don't see anything like it when I am in the app so I wanted to know if it was there and I did not see it. Thanks!
Global Find and Replace for All Sheets in a Workspace/Find and Replace Column Name/Type for All Shee
Is there a way to perform a find and replace on all sheets in a workspace without loading each sheet? Is there a way to perform a find and replace for a column name or a column type for all sheets in a workspace?
Suggestion: Moving sheets into a workspace
It seems that a user cannot move a sheet into a workspace where they are not the Owner, even if they have ADMIN rights to that workspace. It would be useful to have that capability.
Question on Sight image size (Resolved)
I'm trying to build a banner-like image across either 3/4 or the full width of the screen. The height will be some small portion (1/4 or much less) of the width. Is there an algorithm I can use to determine canvas size of the image I'm using? I don't want to spend much more time with trial and error on what is likely to be…
AND + NOT isblank
Trying to produce a formula which says if X is blank and Y is not blank, then check. =IF(AND([Eval Cost]1 = "", (NOT([Client]1=""), 1,0) Thanks
SmartSheet Sights - Shortcut Widget Unable to Link to SmartSheet "Use Template" object
I cannot seem to be able to find a reference to a SmartSheet Template Link to list that Template Link in a SmartSheet Sight Shortcut Widget. I can directly reference the template itself, but I can't seem to find a way to link to the Template Link. ( Not sure of the proper object name for these Template Links ) Obviously I…
Formula for calculating years accurately
We need a formula for calculating years accurately when we compare a date with the date today – some examples would be: * Age in years: Today() - date of birth, currently we use: =(TODAY() – DOB1) / 365.25 but it doesn’t always give the correct answer. The 365.25 is days in a year allowing for leap years, or * Length of…
AND Condition assistance
I'm trying to have the sheet do the following calculation. If the % Complete column of a project row is sitting at 100%, I want the Status Column to change to blue AND type the test "Completed" in the status column. What comes out when I use the AND condition now, is the following: If % Completed is equal to 100% and <set…
Do People Share Templates?
In reading the Pacific West Land Property Management success story, it appears they have created a template that would be extremely close to what I am looking to do. Do users share templates so we all do not have to reinvent the wheel? Thank you!
Web Form Unable to be Accessed
Someone who we've asked to supply feedback via web form received this message: "The form you are attempting to access is no longer active." We have not deactivated the form. The "Deactivate" choice under the "More" option is there. Is this possibly a firewall/security issue on the user's end?
