I have a sheet which is essential reference data. I then have another sheet which will be used to actually do management with, but it needs to "pull" data from the reference sheet. VLOOKUP is only ret…
We have multiple project sheets and our team uses proofs within those sheets. I want to create a report to find out which sheets have proofs attached to them. Is it possible? If not report, is there a…
I have a list of SOPs and their supporting documents (Forms, Logs etc). As you can see in the Excel example, we have the SOPs in Green and the supported docs below. Some, like the SOP Training/Retrain…
I am trying to use reports to reduce the amount of columns and rows I need to handle via the API. Along with this, I would like to have the report also sort the rows, but it seems that when using the …
Hi there - newbie here. Looking for help with a formula. I am trying to drive a metric which shows the percentage of activities on 'THD Brands' in the past week. The 'THD Brand' column is a checkbox, …
Hi , Need a help on the project plan logic related to Sch Health. The logic i am using on the schedule Health is not showing me the correct result. As you can see Start date is 06/01 and End Date is 0…
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet…
Hello, My teams love having personalized reports but the function that we need the most is Proofing. Would there be an estimated time of when that the Proofing Function will be available in reports? T…
I'm building a late task report across multiple workspaces/plans. The filter option is not available when viewing report results. Looking to be able to filter by "Status", "Owner", etc.
Hello everyone, I was hoping some of the pro's on here could help me figure something out. I'm creating a hours tracker for employees to use remotely and I need to calculate the overtime hours as anyt…