-
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?
-
Calculating lateness
I'd like to indicate when activities start slipping behind baseline start dates, using conditional formatting. To do this, however, I need to be able to calculate the difference between the Actual start date (entered manually) and the Baseline start date (locked). What is a formula to do this calculation?
-
Send Update Request
Hello All I want to share an exciting SS discovery! I am currently doing the Smartsheet Project Management course. The send Update Request function will truly transform my work life. This option does not require the person being requested information to log into smartsheet to answer the specific questions I require…
