-
Idea on connecting two Smartsheets?
I have two sheet that i want to reference and update each other. They both follow similar formatting, with one being more of a log/reference for the other. I would like one list to dynamically update the other. How would i do this? Items list - I have a items list that will show an overview of purchase orders to be done…
-
Matching values from different datasets
Having difficulty trying to match 2 distinct values from one sheet to another. We have one dataset that tracks submissions on a daily basis from multiple locations. I been trying to find a way to match 2 distinct values from one sheet to cross reference the master sheet to verify if a form submission was conducted from the…
-
Disable auto refresh?
I want to make a dashboard that pulls data from another sheet, but I only want to update it once a week. Is there any way to delay the auto refresh?
-
Receiving "Invalid URL" When Attempting to Link Into a Share Drive Folder
I've scoured the interweb trying to figure out how to link from my Smartsheet into a share folder using an html link, and have tried several different methods, but keep getting this error message whenver I try. Any suggestions?
-
Consolidating Data from Multiple Sheets
Hello, I'm hoping there's an easy way to do this. I have three sheets, they all are filled in using forms. All three sheets are used for tracking things to be billed to the same list of clients. This client list is identical between all three sheets, if it matters. I'd like a single sheet I can look at each month that will…
-
Adding an additional requirement to a formula
We have been using this formula to add up the hours spent working specific clients -- been working fine. We have also been asking what category of work they have been completing at these clients but haven't been utilizing the data. =SUMIF({Kinsman - Job#1}, [Scope of Work]@row, {Kinsman - Hours#1}) I now need to add an…
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
Cell linking broke my sheet!
Yikes. I was trying out the cell linking feature now my sheet is messed up and tells me to log out and back in. I tried to delete the linked cells and save but it won't let me. I can't save or publish. I can't revert..... Reached out to support but hoping someone can help fix. formName: ajax formAction: fa_gridSave…
-
Can I link an entire sheet into my master sheet?
It looks like I need more than Cell Linking in our master project tracker. Do we have the ability to add a section on our master sheet so that any updates from a separate MARKETING TEAM sheet is displayed in the master sheet? I'm afraid simple cell linking only focuses on cells and won't take into account additional rows…
-
Dropdown CELLs? Please, oh please
Multi-select dropdown columns is great, but I was hoping that the common community request of having dropdowns specific to cells could happen. I currently have hyperlinks to another sheet, but it isn't ideal. Something like the Data Validation in Excel.