Sign in to join the conversation:
I created several fields in the summary sheet. Is there a way to use the filter option in the grid to update the summary fields? I created a date between filter and want it to apply to the summary sheet. Currently it does not work together.
Unfortunately you cannot filter the Summary fields. If your summary fields are populated via formula, there may be a workaround, but it could potentially get a little complex. Feel free to Submit a Product Enhancement Request when you have a chance.
Hello! I have this formula that will check the box if the date in a second column is in the past. Is there a way to include if the date is 60 days in the future? Check the box if the date in Column 2 is either (1) in the past or (2) 60 days in the future. IF([GWO - BST (2yr)]@row < TODAY(), 1, 0) Thank you in advance!
Is there a way to automatically update my dropdown list for a form if I have a new item added? I have a New Order Entry form. I have a dropdown list of customers, but if it is a new customer, there is a checkbox to allow more fields to open up to enter that information. If that information is added, it gets copied to a…
Hi! I'm trying to figure out how to use the NETDAYS formula to show how long someone has been a member of a certain team. I can't get it to measure to today using the formula that the website suggests. I want it to be running so that whenever I log on I can see the time elapsed to the day I'm looking at the sheet. Can…
