-
Can I partially mirror a sheet?
Hi, I hope someone can help me with this. What I'm trying to do is find a way to automatically share some information from a sheet into another. For instance, I want to have a sheet with all the relevant information for the company's projects, including financial information. Then have another sheet mirror most of it…
-
Mark child if Parent meets criteria
Hi- I see lots of threads to mark a parent if a child meets a certain criteria, but I am looking for the opposite. I have Material, Labor, and Subcontractor Parent rows and would like to mark the children with either a number or letter indicating if it is a child of one of those parents (Material =1, Labor =2,…
-
Very Large Save Causes Formula Corruption
I've been trying to understand a problem I'm having with two of my largest Smartsheets. If I move a row up or down or insert or delete a row, especially near the top of the sheet, the Save process will apparently corrupt formulas here and there in my sheet with no warning or error message given. I've gone back and forth…
-
Inserting a Formula into an existing Equation
I have a simple math equation in one of my cells, and in place of one of the numbers I would like to reference a count of cells with dates in them in a certain column. My equation is: =100 - (((60 / 477) * 100)) (this returns a number in a percentage format) and I would like to replace the number "60" with…
-
Multiple, comma separated values in one cell
Hi I'd like to create a report which returns all rows that have a certain value in column 'Donors' - i.e. we have activities that are funded by one or multiple donors, and I'd like to return all activities that are funded by Donor X. Conference one - donor x, y, z Conference two - donor y, z Three - donor x And the report…
-
Calculating Variances with Negative Numbers
How do I do this on Smartsheet? I have an Actuals and a Budgets column. I'd like to compare the 2. So for example, if you have a Budget of 100, and an Actual of 70, then the variance would be -30%. IFERROR((Actual-Target)/Target,0) is all good for positive numbers but I need to ensure it also works for negative numbers. In…
-
Column Lockdown
I have a Sales Report that I have filtered a Column that contains the Regional Managers in this report. The Filter is so I can view the Data only for a particular Mnager and also this is what I would like them to see also is just their Sales portion and not the other Managers. When I filter for them, and share to them as a…
-
Project plan updates and forms
I am using SmartSheet for a project implementation and want to issue alerts using the Forms functionality. How can I include predecessor information for each of the tasks I want owners to update via Forms? Currently, I can provide the users with a listing of all tasks, however they may relate to a predecessor task that…
-
Cell Reference Limitation
We're tracking different divisions within our company on separate sheets. We’ve created summary sheets that reference other smartsheet tabs and we’re consistently hitting the 100 distinct cross sheet references limit when building summary sheets. We figured out how to compile the information for each division via the…
-
UK Contact - Issue with account
Hi, does anyone have a contact number in the UK that works? my account & my whole company is locked out & asked to upgrade when we already have.... this is very urgent!!!
