-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
CARDS - Add parent title to the card
Is it possible to add the parent title to the card as well? It would make it a lot clearer which item you are working on when the parent is different but the child is the same. For example we have a lot of tasks such as: Design Part 1 Develop Schematics Create BOM Create Layout Drawing Design Part 2 Develop Schematics…
-
I would like to send daily reminders of a row to the employee of that particular row till the status
Hi, I want to send daily remainders of a row to the employee of that perticular row till the status colomn shows finished. The colomn names in my sheet are : 1, start date : system generated date and time( this is not visible in the reminder) 2.end date : we can utilize this based on the status colomn 3.emplyoee-1,…
-
Project Resource view | Different colours
Hi Guys, Is there an option in "Project Resource View" to customize the colours? Reason: We are using two sheets, one is for project and other one is for non-projects/leave. We want to visualize diferrent colours for both sheet, so we can have clear overview. Please suggest if there are any other options as well.
-
Contacts
I am using smartsheet to manage insurance claims. We are independent adjusters who go out and inspect a property for damage, then we write a report and submit to the insurance company. I am using one row each for individual's claim data. When the report is approved by the insurance company, I am supposed to email a copy of…
-
Shaing a folder without sharing workspace
Hello, i need to share a specific folder with 5 sheets without sharing the whole workspace. Can't find anyhting on sharing folders and appreciate any help. Thanks!
-
Use API to get Smartsheet Row Id's
Hi In order to intergrate another Application I would like to use the API to request a list of Smartsheet row ID's and selected columns (possibly just 1 column which the the primary key in the other application. This would either be all rows or selected rows. The best output would be as a CSV file eg: mySheetRowIDs.csv ID,…
-
Sight report - collapse and expand lists on the screen
Hi all, We're using Smartsheet sights for our weekly confcall on program progress in full screen "presentation mode", which is really doing great for us. One of the widgets in the sight is showing actual gantt charts per project and it gives us the right level of detail for the call. As the project list is growing rapidly,…
-
SUMIFS - Multiple criteria syntax guidance
Hello, I am am struggling to get SUMIFS working with multiple criteria values. I want to sum data based on Month column and then by probability column. Here are a couple methods I have tried but I cannot seem to figure out what I need to do in order to make it work. =SUMIFS(Month:Month, "March", Probability:Probability,…
-
Feature Request: Sheet Sharing History
I frequently send sheets internally to request for updates through the "Email Shared Users" option. While I know there's a CC me option, I think it would be more efficient if I could find a log in the sheet of when users were emailed rather than digging through my own pool of emails.
