-
How do you change a duration calculation to reflect hours and minutes rather than days?
I am trying to calculate the amount of time I spend on calls by referencing another column from a different sheet. Essentially, providing a sum of the total number of hours, minutes, and seconds I spend talking on the phone with different organizations. When I do this though, even when I change the column type for the end…
-
How to capture current/logged in user when a column value changes
I am searching for a method to record the user currently logged in when a specific change occurs in a field. For example, when the value in 'status' field is updated to 'Reviewed,' I have a need to capture the user responsible for that change in 'Reviewed By' field. The system provided 'Modified by' field is not reliable…
-
Can people with "editor" access still mark tasks as complete? or do they have to be users to do that
I am trying to decide if smartsheets is the platform I want to use for project management of my team. I am a little confused about what a viewer can do versus what a user can do. Can people with the free "viewer" access still mark tasks as "in progress" or "complete?" Or is this only available for paid users on the plan?…
-
Capturing the URL that someone was on where they clicked to get to the smarsheet form
I'm trying to figure out if there is a way to capture the URL for a web page that someone was on when they click on a link to a smartsheet. Basically, I'm using a Smartsheet web form to capture comments about a website. The comments would be about the information on the specific page the user is on. Is there a way to get…
-
Populating blank rows in-between filled rows on a Report
I have 2 different reports with filters that should allow the blank rows to populate on the report and both reports are sorted the same way. The first report populates the blank rows in-between the filled rows, which is what I need. The 2nd report populates the blank rows at the bottom of the sheet. How do I get the 2nd…
-
Form saved as a PDF
Hi, I have a form created (3 pages long) and would like to save it as a PDF. Once I select 'Print/Save as PDF' it would save only the 1st page and usually the page layout is distorted. Thanks! Tali
-
Ownership
It is frustrating when only the admin can make edits to a document. When I share a sheet to someone it say: Editor-can share, but this doesn't allow them to edit the sheet. Is there a way where multiple people can edit a sheet, not just the owner/admin?
-
Data shuttle replace workflows only adding or deleting every hour, not both
Hello, For some reason last night, for all of my replace data shuttle workflows (all run hourly), they have started either only deleting the applicable rows or only adding the applicable rows. Prior to today, each run would delete the rows then add the new ones, but now it does only one or the other. The workflows are set…
-
Weekly Assignment Schedule/planning template
Hello, I'm wondering if, in Smartsheet, exists such template (for a weekly team planning) that can replicate the information below built, right now, in excel. Goal is to have visibility, on the left column, on the each team's work and, in front of each worker, information on their workload (project allocation) per day of…
-
Merge 2 column names from separate sheets into one in a single report
Hi I want to create a single report that can be circulated on an email that pulls data from 2 separate sheets. In some cases I've been able to align the column headings, for example "Assigned To" is common across both sheets. However, in renaming that column, the resulting report no longer has an option to "Group" based on…