Comments
-
There are a few different ways. you could use an Index/Match function on every column in the non master sheet to reflect all of the updates. If you have access to the premium add ins you could use data mesh and create cell links.
-
Hey @Danielle Wilson , It's reference DataTable
-
Thank you Carson, that worked perfectly.
-
Are you cross referencing a different sheet or are all of these on the same sheet?
-
Hollie, try the below =COUNTIFS({2023-2024 Call Monitoring Archive Range 2},>3,{2023-2024 Call Monitoring Archive Month}=7)/COUNTIFS({2023-2024 Call Monitoring Archive Range 5}<>"",{2023-2024 Call Monitoring Archive Month}=7)
-
@MeganJF , add the below into the formula IF(ISBLANK([Total Value to User Score]@row), "",
-
Hey Gregory, This one hurt my head for a second but I finally figured out a work around for you. I am assuming you are having them identify their department within the form, and then a column that identifies the Date entered. Create an auto number column in your sheet. Then create a column titled "Work week and place the…
-
Good afternoon Claire, You can easily accomplish this with a sheet automation. Please see screen shot for the set-up.
-
Is the Template an Excel File or something else? If it's an excel file, is there a reason why you can't use the form to collect the data?
-
Chris, do you have access to the advanced Smartsheet functions like Mesh and Shuttle?