-
Report that includes multiple sheets
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
-
Servers unavailable
I’m currently getting ongoing intermittent errors trying to link sheets together. It says servers are unavailable, yet it is OK when I click Save on the sheet. Also looks is happening around the same time which is around 4pm UK time, any ideas?
-
Capturing Cost Savings by the month
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
-
Automatic emails for approval - intermittently not sending
I have had approval workflows and notifications built into a couple sheets for about a year now. In the past month, I am getting a lot of feedback saying people did not receive the email request for approval or notification email. It isn't all the time, just sometimes and there does not seem to be a pattern on which ones…
-
how can i overlap 2 tasks.
Hello, i've a question about 2 tasks. Task 1 has for example 4 hours and should be on day 1 for example 6 january. Task 2 has 30 hours and should be on start on 4 january and futher. How can i manage that on 6 january task 2 has only 4 hours? Now i got the message user is over-allocated because task 2 is planned on a full…
-
How to optimise my currentTimesheet solution
Hi community, hope you are all spending a great xmas period. I'm here to ask you advice on how i could improve or change completely the architecture of my timesheet solution. I have setup up a sheet with the following main columns: Work date - Contact - Project Name - Activities A total of 15 users enter their activity…
-
Bullet Points
Alt 0149 is not working. Is there another way to create bullet points in cells?
-
Duplicating a sheet and retaining formulas, mappings and automations
We have a monthly Tracker which contains a variety of automations, links to another sheet, mappings and formulas. We need to create a copy of this sheet to then use for the next month, but retain all the previous mentioned automations, etc. However, using the SAVE AS function does not allow us to do that. Are there any…
-
Writing Formulas in Smartsheet - Self Paced - Optional Activity
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
-
More granular time options for needed for Workflow triggering
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
