-
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
-
smartsheet does not automatically refresh
After someone submits a form, I would expect my smartsheet to refresh so I can see the new row. That is not happening nor has it since I built this sheet. I have to manually refresh the page. That's not normal, is it? What do I do to make it update automatically? Thanks
-
Web Forms and Paypal
I'm working on registration form that in the future we'd like to add the ability to pay online. Is it possible to add a pay feature to a web form?