-
Create a new row when a cell is updated in a report
I have a Report that pulls from a source sheet. When the data in the Report is updated, I would like it to create a new copy of the row in the source sheet rather than updating the existing one. Currently, since the Report is directly linked to the source sheet, any changes made in the Report overwrite the cells in the…
-
Question on Forms
Good afternoon. I have a question for you. I am using Forms for my spreadsheet. I have 7 days beginning with Monday. I wanted to do different sheets for each day. This is so the user would not be confused. Each day is placed on a separate row, Is it possible to have the forms Mon-Sunday show on the same row? In other…
-
Datamesh compatibility with Table View
Could we get a status of when DataMesh will be compatible with Table View? I'm probably not the only person who would like to move to Table View with sheets with large datasets which are updated with DataMesh, but are prevented from doing so by the lack of compatibility with AddOns other than Data Shuttle. When can we…
-
Forms to specific Fields
I am trying to create a vacation tracker and Form request. I created the grid and form, is there a way to get the form to fill for a specific line in the tracker? Instead of just top or bottom and then having to move the information manually?
-
My Request for update doesn't work as it should be
I have been testing this function of request an update and it doesn't work. What we want to do is, if the conditions are met, it should trickle the request for update every day up to 4 days. Can you help me check to see why it doesn't work? See pictures below as a reference I also have another issue that some of my regular…
-
Sort and filter on a report in Smartsheet without being an Admin on the connected sheet
Is there a work around to sort and filter on a report in Smartsheet without being an Admin in the sheet it is connected to? Even when the person is an Admin on the report
-
Automation Workflow "run once"
I have a date field that when reached I want to send a reminder email to the users. My question is will this automation literally run once when the next send reminder date is reached or will it run once each time one of those dates is reached.
-
Automate Update request gives access to view entire sheet
Is there a way of using automation for update request without giving the assigned person view access to the entire sheet? I don't want to do manual requests on each row. Also if they are not a viewer the automation fails. The email that goes out has 'go to the sheet' on the bottom which allows them to view the whole sheet…
-
Merged: copy cells or columns with automation
This discussion has been merged.
-
How do I have tiered authorizations?
As noted in the attachment, what I am looking for is a system of sign-offs where each person can sign off on a document and then it automatically fowards to the next person in line OR if the have changes, it gets sent back to me.