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
NOTIFICATIONS - THANK YOU, THANK YOU!!!
I am beyond thankful for the major improvements to the Notifications area in Smartsheet. I love every aspect, and our team is very pleased. Can't wait for the reminders improvements - that will be an even bigger benefit for us!!! Blessings, Loann
Select RYG color based on other cells
I have a sheet with checkboxes in 3 columns, and I'd like to have an RYG symbol in a separate cell be red if 1 box is checked, yellow if 2 and green if 3. If no boxes are checked I'd like to have no RYG symbol visible. I am assuming this needs to be some combination of IF and COUNTIF, but I have tried different…
My profile issue
Minor point but have been unable to add a picture to my profile even though it is less than 1024 x 1024 pixels. Does anyone have any thoughts? Mnay thanks.
Notifications or Reminders
Hi, Is their a way to set auto Notfcations when a cell is a nagtitive number my example on a sheet is if Payments to A/P (A/P is payments made to Vendors in that month) in Box A/R Payments Recevied (in AR Box i have monthly Income Recevied to Date) Net Cashflow =Ar -AP = Cashflow Available if the amount is in a minues i…
Calling a client from a sheet
My phone doesn't highlight a phone number for calling from a sheet ....my colleagues i phones do / I'm using a Samsung galaxy note 4 !!! Is it me ...the app... or the phone ???
Calculate % Comp but retain dependencies
Hello. This seems simple, but it's stumping me. I have a project Gantt chart, and some of the child tasks are simple numerical completions of tasks. In other words, if I have 300 of a certain thing that need to be done, and if I have a user input that he or she has completed 100 of these, I can calculate a completion…
Using formula to average columns with rating stars
Hi Folks, See my screen shot below. I am trying to get score cell circled in red below to look at the star rating symbols in the child rows and provide the average of the child rows in the score cell. I am assuming that 0 stars equals 0%, 1 star equals 20% etc.......... Help pointing me in the correct direction would be…
Edit information on Sight
Administrators for particular Sight sheets should be able to create widets that allow the user to edit the information. For example: If I am presenting to a team of people using Sight, the layout allows for a clear reflection of information, which is awesome! The problem is if the presenter wants to make a change to a…
Disabling web forms
Hi, I would like to know if there is a way to deactive a webform automatically on a particular day and time vs. logging in to click the deactive link? Thanks in advance, Kate
Date column changing the default behavior of a column
I have a date column called Date of Resolution . I also have a column next to it called Resolved? which is a drop down of either YES or NO. What I want is the Resolved column to automatically fill in from the behavior of the Date of Resolution column. If the Date of Resolution cell is filled in, then Resolved changes to…
