-
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…
-
Using time formula to create a master schedule
I am trying to create a sheet with a formula that calculates total time worked in a day, from a start time to an end time. I want to show who is working in specific units, from 8:30am to 7pm, at 30 minute increments for a 18 week period. See my pdf mock up attached. I created it in Excel. Any help would be a big help!…
-
Countifs within date ranges
I have - a column containing weekdays, that spans a complete school year. a column containing an assortment of names that re-occur on a random basis. I want to count how many times each name occurs from the start of the date range, but only up and not beyond today. Any help appreciated!
-
Changes By Multi Users
HI, Cna you please confirm how one can view the changes made by other users, if that is a shared workbook? How one user will know that second or third user is working on same row/column so he avoids going to those cells? Regards,
-
Round up & If Condition
Hi, Hope this message finds you well. In Ms Excel, we have following function available, how can we have the same in Smartsheet? MROUND(AVERAGE(V2:Y2),0.5) Moreover, need to implement the same formula in smartsheet. IF(OR(AA2>0,AB2>0,AC2>0,AD2>0),"C","NC") Thanks in advance :)
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
Maximum Limit - Columns, Rows & Cells
HI there, This is the maximum limits of SmartSheet. - Max rows: 5,000, Max columns: 200, Max cells: 200,000 What if I have a whole excel sheet and need to import into Smartsheet, what to do? regards, t