-
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…
-
Can an intake form populate more than just a new horizontal row in a sheet?
I have timeline templates built out in a cascading fashion (with parent and children relationships) using "workday" formulas and a holiday list. I'd like to start the timeline off with an intake form. The customer would enter the timeline type (telling smartsheet which template to pull) and then the start and end date of a…
-
Saved Views
We use Card View for tracking all of our open jobs as they go thru each process and department in our company. It is an invaluable tool for seeing visually how jobs are progressing. What would be a good addition is if there could be saved views. This would use filtering and also show different fields in card view and…
-
ENHANCEMENT REQUEST!!
I created a scheduling system using a grid/form/dashboard. After implementation I found out that forms do not have any permission settings. Ex. I had a grid/form that I only want 10 people to access, the grid is restricted but everyone can access and submit using the form. For this project to be successful, I either need…
-
Automatic Deletion
I am looking for a way to set up an automation for deleting rows in a sheet. My firm is unwilling to go through security testing right now and is wary of putting sensitive data on Smartsheet, but is wanting to use a form to collect the data. They propose that a notification is received when someone fills out a form and the…