-
Chrome app closing without a warning
Hi all, When I run smartsheet in chrome browser, if I try to close the tab and there are unsaved changes, I get a warning about that. However, when I use the chrome app, if there are changes to be saved and I close the app, then it closes without any warning, and hence those changes are lost. Is there any way to fix that…
-
Web Form Submissions Disappearing
Hello, I have a web form that I'm using to collect information, and it has been brought to my attention that a number of rows that were submitted by users, and for which they received confirmation emails, never showed up on the sheet. This poses a huge problem as each submission represents a request to process a payment,…
-
Relationship between the "Status" column and other columns
I'm relatively new to Smartsheet, but it seems strange that the Status column appears not to have any relationship to other columns in the project sheet. But maybe it's possible to use a formula somehow to do that? Some specific questions: * If I change a task from Not Started to In Progress, can I set up Smartsheet to…
-
O365 Integration for unlicensed users
We have a Business plan with 15 licensed users, then will invite perhaps another 100 collaborators (unlicensed users) as part of the various projects across enterprise. All same organization. We are an O365 shop and have integrated all licensed users with O365. However, there does not appear to be anything but a static…
-
Nested IF statement for RYGB only works in one row
Has anyone come across a scenario where your nested IF statements work perfectly on one row, but when dragged to other rows don't apply the conditions correctly? I've added the following statement to row 47 of my sheet: =IF([Percentage Complete]47 = 100, "Blue", IF([Percentage Complete]47 < 33, "Red", IF([Percentage…
-
Sights Widget to Display Update of Any Changes of an Entire Sheet
I Desperately Need Help with understanding how to use a report and/or widget feature to display an automatic update of date whenever anything on a sheet is modified or changed. I would like for this to pop up on the dashboard I am creating as "Last Updated As: 5/5/2017" for an example. Can anyone please help? I have…
-
Smartsheet unresponsive
I logged into my account and all my data is there but the page is unresponsive, I can't even select a cell.
-
Counting A Range of RYG Balls at Once
I have researched and tried the various formulas for counting the RYG balls in one column from 1 row through 540. I have tried various formulas but I keep receiving and error. Can someone help me by letting me know what I am doing wrong? Here are few formulas I have tried. =COUNTIF(CHILDREN([Status of Completion]1:Status…
-
New suggestion for the reminder feature
Hi Thanks for the great feature that you have added to the notification roles I would like to Suggest adding the customization feature to the column that we want to present in the email message for the reminder alert when we edit the message. Best Khaled
-
How to use a widget to be able to add a modification date in sights?
I would like to know how and I add a widget to my sight page that will automatically update whenever there are any changes or modification done to the associated sheets it is linked to. I see something similar on one of the examples on the sights help pages and videos but it doesn't exactly go into details on how it was…
