Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use Button & Select in Field to filter sheet by date variable

  1. I would like the end user to be able to click on a button to filter the select to only those contracts ending in a date range based on filter.
  2. User inputs date in input box and it is store to variable vFCSDate.
  3. User then clicks on a button to filter just those within the date range.
    1. I created a button and used Select in Field action with this code:
    2. =END_DATE >= $(vFCSDate)-30 and END_DATE <= $(vFCSDate)

  4. I am trying to find a way for uer to input an FCS Date and trigger the sheet to filter only to those contracts with end date in the 30 day range before the FCS date.
0 Replies