-
How to avoid duplicate entries in a report due to linked cells in multiple sheets
I am close to creating a calendar (report that only shows activities across sheets with duration < 15d), but have run into an issue where certain activities or milestones are showing up twice because they are linked between sheets. Other than manually identifying these linked cells (checkbox, etc), any ideas for a more…
-
Formula Working in Most Rows, but Incomplete in Others
We have a sheet that automatically generates a job number based on how someone fills out a web form: =IF([CLIENT - REGION]1 = "HMA - Hyundai Motor America", "HMA", IF([CLIENT - REGION]1 = "HDAA - Hyundai Dealer Association", "HDA", IF([CLIENT - REGION]1 = "ADI - Adidas", "ADI", IF([CLIENT - REGION]1 = "MOGUL - Federal…
-
Sheet Speed problem
I have a sheet we are using to track payments etc with the layout is simple First Col is the Colored dots Red/Yellow/Green Cols 2 to 7 are just plain data 3 are date fields the rest are text Col 8 has the only formula = TODAY() - [Check Date]1 However the issue is the speed of the sheet, it acts very sluggish and the first…
-
Mobile App Update Requests
Is it possible to track update requests in the mobile app? I know we can send update requests from the app. But, I don't believe we can view update requests that have already been sent. Please prove me wrong! Thanks, Dustin
-
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…
