-
Date changes to tomorrow after 5pm
Hello, I have been trying to find a work around for an issue I am having on sheet we use. We are currently using a sheet for employees to submit when they check out and check in equipment via a form. We were using the auto created date column to run reports on what equipment were checked out vs. available. We discovered…
-
Best way to manage an iterative process in Smartsheet
We are planning to implement a book publishing project in Smartsheet. At one point in this project, the pages of the book go back and forth between the writer, editor and compositor till it gets finally approved with no further changes being required. The number of times this cycle repeats itself is unknown, however there…
-
Company uses smart sheet in metro manila philippines
Hi is there any company here uses smartsheet in philippines specially in metro manila? may i know the company name thank you
-
Smartsheet overrides workflow approval
I have a multi-step workflow approval set up. Form entry submission sends an initial request to the manager. When manager approves, next approval goes to center administrator. Once that's submitted, then it goes to one more and then the director. Problem is that smartsheet is overriding the "Approved" status from…
-
Number of Days Ticket is Open
Hello all. I am a newbiw to Smartsheet, and I'm having trouble correctly adding a formula to one of my sheets. I have a repair sheet with a column that shows the date the ticket was created and a column that is labled number of days open. How can I have this column automatically display the number of days the ticket is…
-
Formulas Auto-Populating in a Newly Added Row
Everytime I add a new row in my sheet, I have to go in and make the formula go onto that new row. Is there a way to have the formula auto-populate whenever I add a new row into the sheet?
-
Manually Adding to Reports
I'm looking for a way to pull information from other sheets, while also being allowed to manually add data. The reason I'm doing this is to allow for staff to go to one place where we can share individuals goals, tasks and progress. Is there a way to do this? I have tried formulas, but I do not believe it updates when that…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Agendas in the meeting templates
Hi - I'm working in the agendas, and in the template, there's upcoming, past and new agenda submissions. In the dashboard, it has previous agendas and upcoming agendas... How do I get that to update to the next agenda? The first meeting I did is over, do I have to make a new form for the next meeting and link it, or can I…
-
Group not totaling correctly
I have groups and sub-groups (I hope I'm using the right terminology, I have 8-rows indented under another row) and only the first four rows are totaling. The calculation is for Duration and I am using days and hours.
