-
Format as time
I need to keep accurate documentation of how long my deliveries take (down to the minute) I normally do this in spreadsheets by having the column formatted as a time. I cannot see that option in the formatting list. Am I blind or is it not there?
-
Calendar View - can't drag tasks when Due Date uses WorkDay function?
My SmartSheet has Task Due Dates that are calculated using the WorkDay function. For example, if a recurring monthly task is due on WorkDay 1, that calculated Task Due Date would become Monday, January 3rd, rather than Saturday, January 1st. Approaching the dates in this way makes it easy for us to rollover the Task List…
-
Need way to add a counter on a dashboard for user "views" or visits
Hi everyone. Absolute beginner here. I'm tasked to make a few dashboards for other internal company teams on project progress, etc. We want to track how often people visit each dashboard and thought it might be useful to include that as a counter widget on the dashboards. Mockup example below. Doable??
-
Please add a successor column or function
A way to show successors is needed. It's important for critical path scheduling that every task has a predecessor and a successor. After a couple hundred lines it becomes nearly impossible to eyeball everything to make sure that's true. A successor column allows one to simply filter to find the missing successors. Thanks.…
-
Is this "Jira Connector by Smartsheet" add-on was compatible with Jira Server version 8.4.2?
Hi Team Is this "Jira Connector by Smartsheet" add-on was compatible with Jira Server version 8.4.2? Can anyone help me with this? TIA, Tirupam
-
COUNTIF Formula for Contact Column
I have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that counts the number of times their email address is in the Contact column. However, the…
-
2 or more projects sheet dependency
HI, I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sheet. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> For example: Project A sheet Task # 25 on…
-
Moving Attachments from Pivot Source Sheet to Pivot Target Sheet
Hello, I'm using a source sheet to collect tasks with basic requests and attachments. I'm then using the Pivot App to organize these tasks by subject, which essentially makes the parent row a main task, with each child row as a subtask that needs to be completed first. This piece of the puzzle is working as intended.…
-
Go To Today in Calendar
The calendar view really needs a "jump to today" button. Click it and today is positioned at the top of the month view.
-
One Approval for Multiple Lines/Whole Sheet
Hi everyone, I have stuck with this problem for a while and seen many questions about how to consolidate the approval requests to be sent in one email. It seems like the only solution so far is to create a report with a approval column that has checkboxes for approve, deny, etc. My concern with this way is that, in case…