-
Index-Match cross-sheet reference for a Contact List column
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulling it back, but it is not formatting the column as a "contact" - it looks like plain text (no contact "circle") This is my…
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
Get Sheet (ID) by Name using Smartsheet API
I was wondering if there is a way to get the sheet Id of a specific sheet using the name of the sheet. Get sheet accepts the sheet id to get the sheet info, but I would like to get the sheet using the name. In Bridge, you have the option to get sheet by id or name, so I was wondering if there is a way to get it apart from…
-
Copying Data from Locked Cell as Editor
My team is looking to lock a cell so that only admin's and owners can edit the column, but we need our other team members with Editor permissions to be able to at least copy and paste the cell and have the data move with it to a new row. Currently, an Editor cannot copy the cell and paste and have the data show up in the…
-
Link % completion and Status fields
We have 2 columns. 1) % completion 2) Status (not started, in progress, completed, significant delay, etc). We would like that every time we move % Completion from 0 to any number up to 100, Status gets automatically updated to "in progress". And when % completion hits 100%, then Status is "Completed" We will still want to…
-
Lock or Store Date/Value Solution without using Zapier
Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it…
-
Automatically Sort Rows in Sheets
As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.
-
Group Rows in Sheet, not just in Report
I would like to view rows grouped by their category (from a dropdown column) in Sheet form, so that I can add new rows while viewing my data in an easier-to-read format. Currently it seems grouping can only be achieved in a Report which does not allow me to add new rows. I am new to SmartSheet but have intermediate…
-
Ranking by score
Hello, I have a sheet that contains people and scores (1-100) based on their performance. I want to create a table to show the top 10 and the bottom 10 people based on their score. Any ideas on how to do that? Regards,
-
Stop Predecessors from being deleted when a date is deleted
Sometimes we need to just delete the dates to start fresh or copy rows to use for another project, but deleting the dates also deletes the predecessors. I was trying to test a schedule template with many hours of work on defining the predecessors. When I wanted to blank out the dates again so it could be used as a blank…