-
Capture Row history using API?
I am trying to build a UI using Google scripts to display the changes made to any given row. In other words, I want to capture a list of modified date, modified by and what was changed in a row if any cell in the row was updated.
-
Dashboards
Hi All - I am trying to create a dashboard to be shared with the team(s). Something with colors would be great! A list of all the projects and their status in a graph (or pie chart). Something with colors would be great! Any ideas?
-
Smartsheet for Inventory using QR codes
Hello everyone, I'm a teacher who has to manage a "MakerSpace" - a design studio with lots of electronic equipment. It would be ideal if I could place a QR code sticker on an object, take a snapshot of it with the camera on an ipad, and arrive at the inventory Smartsheet that I've created where this object's original…
-
Row Sharing
We use Smartsheet in our IT dept. for a few months now. 13 licensed people at this moment, especially to manage projects/tasks, in EMEA, China and US and we like to expand. Everyone was very enthusiastic in the first weeks, but the biggest problem is: row sharing. We work with external consultants a lot and we want them to…
-
Alerts to Microsoft Teams
When trying to set up an alert to Microsoft Teams from a Smartsheet Workflow I am getting the below permissions message. I have spoken to my Office 365 Admin and he is not sure what to do. Is there a link to an instruction on how to do this. This seems like it should be straightforward but I can't find anything.
-
show last comment in Cell
is there any way to define command for cell to see the last comment in the cell it will improve the tracking Tasks , to see in front the last comment in the SS and not go enter to the comment in advance … to enter the comment in cell and log it direct to the comment log\screen
-
E-mail notifications
Hi, I have a 'Sheet' named 'Main sheet' with forms submissions arriving all the time, within the 'Main sheet' there is a field called 'Employee Department', when populated from the form this looks up the 'Project Sponsor' from a further 'Sheet' named 'Lookup' and pulls the e-mail through to the 'Main sheet' - this all…
-
Alerts For When Nearing 5000 row Limit
Is there a way to set up an alert on a sheet for when it is nearing the 5000-row limit? Thanks!
-
Formula to look across rows and columns in a table.
Hi there I need a formula that will look across rows and columns in a table. For example, I need the result for School District-B with 23 items. The result from the table below should populate with: $350 1-5 6-15 16-25 26-50 51-100 100-50000 School District-A $100 $200 $300 $400 $500 $600 School District-B $150 $250 $350…
-
Alert when there is no attachment
Is there a way to send an alert when a record has no attachment? I have a sheet with checkboxes indicating documents have been attached. I want to get an alert if someone checks the box, but forgets to add the attachment. Anyone have any thoughts on how I could do this?