-
Copy / Paste to create links
I am trying to copy and paste special/links to copied cells; however the "links to copied cells" radio button is grayed out. What am I doing wrong?
-
If project status complete - stop calculating formulas & Conditional Formatting
Greetings, Currently at row 1600, waiting for a cell's formula to process the formula may take up to 10 minutes. For instance, sometimes when I change the duration of a Child row by 1 day, it may take 10 minutes for the End Date to advance by 1 day. I use A LOT of formulas, cross-sheet references, as well as Conditional…
-
Most Recent Form Entries Metrics
I have a Sheet which is populated by a form, and then calculates prices based on the entry responses. I want to create a metric on my dashboard that displays the pricing information for only the most recent entry, any tips? When I tried linking it to the cells in the top row, it seemed to be a link to that particular cell,…
-
Help Needed: Creating more efficient ways to update sheets
Hello, I am working on providing dashboards for my seniors. Here is the premise: I have multiple project managers (PMs) that work with four different agencies. Each PM has their own assigned sheet and assign an agency to the project. To create a dynamic dashboard, I am using a separate sheet (a table sheet) that pulls info…
-
Email based on cell value?
Is there a way to send an email containing the data from a row automatically based on the value in a cell? For example if they choose "Accounting" from a dropdown list or contact list in the "Department" column in row 1, then it would email the data from row 1 to the address on file for the Accounting Department.
-
External URL
How can I make a link to an external url so people can click on the link and it takes them to open up a webpage?
-
Average Value Errors
Hello, Was hoping someone could see what i am doing wrong here; i am attempting to take the value of two cells and average them. Both are percentages. i use the formula =AVG([average calc]33, [average calc]34) and i get the "DIVIDE BY ZERO" error. From what i read this may be due to the particular column is a dropdown list…
-
Links
Is there a way to globally add/delete links between sheets or does each link need to be added/delted individually?
-
Cell contents into Text String
Hi, I'm trying to create a column that essentially mail merges within the cell by pulling from previous columns. For example: "[Name] is [Age] and attends [School Name] school." where the bracketed terms are columns in the sheet. Can I do this in Smartsheet or is it restricted to Excel so far? Thanks!
-
Reports Book Not Working
Hi, Not sure if anyone can help me on this, as Support haven't responded after emails sent 3 weeks ago... I have created a report that pulls in information from different sheets, on specific criteria. when i set this criteria in the filters section on each individual sheet, i return 243 results from all 3 sheets combined…
