-
Automation from 15 smartsheets to 1 Master sheet
I tried Zapier but ran into two issues. 1. all the sheets must be active all the time.. Zaps will not Zap unless a sheet is inactive. 2. I need the rows added to the master sheet added per division NOT at the top or bottom.. What am I missing? I know that I can copy and paste the rows which is ok.. Just wondering if the…
-
View formulas globally in a sheet
Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying the underlying formulas). I find this very helpful to: - Discover which columns I want to shade grey to indicate that they…
-
Linking Data
I need help linking data from one sheet to another. I need the data to update real time, so that should a salesman update a projects, or ad another project in that satisfies certain requirements, the data automatically updates in real time on the linked page for my operations team. Reports will not work for this.Reports…
-
Sight - sharing via email a PDF version
Is there a way to share the sight the same way we are able to share a regular sheet? sending it via email in PDF format at a certain frequency rate (monthly, weekly etc)? Thank you Luiz
-
Rollup child rows for a particular parent row from multiple sheets
Hi, I have many Country sheets (Singapore, Japan etc.,). In each country sheet, there are multiple sectors (Media, Financial Services, Technology etc.,). These sectors as setup as parent rows and there will be child rows for each of these sectors. The child rows are not fixed in number but the parent rows are. I would like…
-
copy row from one sheet to another by using the formulas of the new one
Hi @ all, I haven't found any solution regarding by topic within the community articles. So maybe there is a smooth and easy solution for my question. We set up 8 identical sheets (formulas, rows) with a lot of fomulas. Why 8 sheets - because the maximum of a smartsheet sheet is by 5000 rows. ;) So if we would like to copy…
-
Automatically Generate Decision Log from Action Item List
I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever the value of “move to decision log” is selected from the next steps column in the action item log I would like for a line item…
-
Copying Alerts/Reminders
I use smartsheet to manage my new client implementations. Each new client gets a new smartsheet. The implementations are tough to manage beacuse of all of the different pieces of information and tasks that are needed from different folks, both internal and external, for for each implementation. Smartsheet has been great…
-
Checklists on tablet/device
I am just wondering if there is a better way to set up QA sheets so that they are able to easily be checked off on a device (tablet/iPad)? It would be great if we could just go line by line touching the box to tick it, but what actually happens is the edit line page appears and it has to be filled out that way - which is a…
-
User-submitted forms: Is there a way to have email address and name be automatically added to my Con
I have an "Update Request" Smartsheet, where employees can submit a request via a form. The 'name' and 'email' fields are both required, so I'm capturing those fields on every submission. BUT even though someone enters an email address and name, I still have to manually add that person to my Contacts. How can I set my form…