-
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…
-
PM Solutions
It's going on 14 days and I still have no idea how to access the Solutions PM templates discussed in this webinar: https://www.youtube.com/watch?v=fGdbyfiYFZo Customer Support has been no help what so ever. Can anyone provide LINKS to the templates, because Othello Barbosa e Silva | Smartsheet Sales Development…
-
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…
