-
Counting only weekdays Formula?
Hello, I have a ticket tracker where it counts how many days a ticket has been open. Currently it includes weekends and i don't need it to. Is there a way or formula to count the amount of days a ticket has been open excluding weekends? I have a date created column and then a date closed column and use this formula current…
-
The smallest date with a specific status in the child cell
Hello community, I hope this message finds you well. I need a formula to classify as TRUE if my row has a "Not Started" status and presents the smallest start date within the cells, which in the example figure, are filled in white. However, I couldn't come up with an efficient result. Any tips or help to build this formula…
-
Allow copy of a direct link to a specific attachment in a row
I would like to suggest an enhancement to copy and send a direct link to a specific file Attachment to a row, when there are multiple files attached to the same row.
-
Update Request Complete
Hi, Is there a way a completed update request can be re-instated? I have a situation where an automated update request was sent with 13 rows. The person completed a couple of rows and submitted them. He then went back to the same link to complete the other rows. The form allowed him to fill in the details; however, when he…
-
Group Columns in Grid
Hi! I use a really large grid-style Smartsheet to track all aspects of project development and health. It would be very helpful to have a way of grouping columns. The hierarchy for rows works great, but I think with columns I am just looking for a way to clean up my views. I feel like the best (and only) solution right now…
-
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
-
How to make Value be based on a cell for Automations?
Hello, I have a automation where i need it to trigger when a cell matches another cell value. So I have a column with an requestor email that is inputted by a form that Person A would fill out. I also have a modified by column to show who was the last person/automation to modify it. I also have a text field for additional…
-
Restrict Who Can Delete Sheets
I recently had an unlicensed user with Admin permissions delete several sheets that I own. I was able to recover them since they fell into my deleted folder. Can this be restricted to only the owner can delete a sheet (I thought this is how it used to work?) Or can there be a notification set up to the sheet owner if…
-
Allow Unlicensed Users to Hide Columns
Is it possible to allow unlicensed users with certain permissions the ability to Hide a column.
-
Mind Map View (WBS View)
Add Mind Map View which would be a graphical representation of the work to be done or simply WBS. Obviously, Mind Map View should be created based on your list of tasks in Grid View. Having such a clear, hierarchical, and structured view of the entire project scope would be incredibly useful. The ability to choose how the…