-
Company Holidays
Currently Holidays can be configured in 2 locations on Smartsheet. At the administrator portal and at the sheet level. It would be ideal if at the sheet level you could select pull in holidays from your administrative settings. This should be something you can do when creating a new sheet from a template so that you do not…
-
Inventory Formula Question
I am trying to keep track of items we have to give out to community members. Mostly I am just making sure I know when I'm getting low on a certain item. I made two sheets, one with the name of each unique item and one with more details that allows me to keep track of the person and date the item was given. Those details…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
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…
-
Can I write a cross-sheet formula that works if one has one and the other has many?
Here is the use case: Smartsheet A: Lists selected clients once per row (includes a column with a unique client ID). I created a drop-down column for each product with yes or no picklist. Smartsheet B: Lists clients on many rows (includes a column with a unique client ID). I developed a formula to enter "Yes" IF the the…
-
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…