-
auto update from multiple sheet
Hi, i'm looking for someone who can help out in setting up smartsheet for the company.
-
Cross-sheet references
I'm getting the error code #CALCULATING, which I think is because I must've gone over the 25,000 limit for cross-sheet references. The sheet originally had upward if 4500 rows and I've removed more than half of them now but I'm still getting the same error. Can anyone help with this please?
-
'Find & Replace' functionality in SmartSheet?
Is there a way to use a 'find and replace' functionality across the entire estate of worksheets through utilising Dynamic View coupled with Reports?
-
JIRA Pro Fields
Has anyone used JIRA connector to update cells in Smartsheet from Pro Fields? This is a main functional requirement of our use of the integration tool and really want it to work if possible...Thanks!
-
Using COUNTIFs with FIND & AND
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…
-
Pull in % Complete into a new sheet (pivot view)
Hi I am looking to create a ‘pivot’ view of my sheet that will show the 6 stage gates going across horizontally, so we can see going down the sheet how we are doing across all sites for system, users, WoW, etc. I have created a new sheet for this view and plan to reference in the 3 project sheets. It was recommended that I…
-
Expand column width
Hi, Refer to below image, there are few collapsed columns - I'm not able to open them by draging the edge of the column, any tips how to expand them? thanks.
-
Add lines in templates and have the formulas auto appear
Hi, So I created this template for our sales team. The idea is that in the yellow boxes they enter item number and quantity (and other things based on where they are in the template) and was informed that there are some sales orders where they will need to add additional boxes. We were looking to have it set up so that one…
-
Reference Single Column from Sheet Range Reference
Is there a way I can easily reference a single column from a wide Sheet Range Reference? I have 50 columns on a separate sheet, each one I need to run a COUNTIF() on. Rather than creating 50 range references across sheets, is there a way I can reference the whole range, as you would in a VLOOKUP, but then reference the…
-
Help With Getting a IF statement to work when using columns referenced from another sheet
Hello all, I have a sheet that I'm trying to get the elapsed time in days from when a ticket was open to when it was closed. I am doing this using a second sheet, so the formula uses sheet references. I am having trouble getting this to work when using a range of items. When I use the COUNTIFS function, using areferenced…