-
Please help me with this sheet
I currently have data which is in sheet 1 of my sample sheet attached. I am expecting an output in the format I have made in Sheet 2. The formulae that I have tried till now for the same is in sheet 3. Here is the link to the sheet :…
-
Workspace to share Reports
Hi, I created a workspace, I drag the reports to the workspace and then share the reports by adding people contacts. The people can find the reports in the workspace, but when they open the reports, they are blank. Why? What shall I do? TC
-
Adding Time Values
New to smart sheet but couldn't find an answer to this question! Is there a way to add several time values to a total (ex. :15 + :15 = :30)? My goal is to sum all overtime minutes worked during the week into a running yearly total. On my spreadsheet I have a Total YTD Hours Column, A column for each day of the week that…
-
Alerts & Actions: Send a notification when a comment is added or updated
Does anybody else no longer see the option on the dropdown list to "Send a notification when a comment is added or updated"? (see red circle in image attached) I could clearly set this notification up in the past. (see blue circle in the image attached. Thanks!
-
User Changes Report
Is there a way to set up one report that shows all changes the user has made throughout any/all spreadsheets in smartsheet on a reoccurring basis (daily or weekly) ? *It would be helpful if the report showed the actual line item changes and not just the sheet link with username, date and time.
-
Inventory checklist
I have to create an inventory checklit based on an Excel document I will have 2 main sheets: Inventory & Picks Inventory will have a list of all the SKU/units that we have per product. Picks will need to offer me the option to select one item from the Inventory sheet and once I pick it, it has to tell me if we have enough…
-
Row order
when you log in to smartsheet from cell phone, the oldest info in at the top. you have to scroll through all these rows to get to the most current entries. Is there a way to set these sheets up, kind of like an e-mail in box, where the newest info is at the top?
-
MsProject import to template
I need to import a Project from MsProject, but I will like to import it to an existing template. But every time I try to import it from the template it will open a new sheet with the Ms Project info . Is there any way to import the MsProject directly to an existing template ?
-
Auto pre-populate a web form
Good day, I would like to pre-populate a smartsheet form with values in certain columns. I see that you can auto populate a section of the form by manually entering (post-URL): &ColumnName=text. However, I want to avoid having to create each URL by hand, this will take forever. Is there a way to automatically generate the…
-
Gannt Chart - multiple milestones on the same row
I want to set up a recurring set of weekly meetings over a 3 year project on a single row. So far the only way I see to do this is to have a separate row for each meeting....painful. I can do a roll-up, but it graphically shows as a continous bar. Preference would be a series of diamonds (milestones). Any ideas? Much…