Hello.
My LOB uses Smartsheet as a form of staff management system. This includes essentially creating a Workforce Management (WFM) tool in Smartsheet. Using Bridge I have managed to automate many of the daily attendance process and am now looking to add a flow to auto update time off requests to approved for future dates where there are hours available. Requests move through 1 sheet and another does a rolling day over day series of calculations for the number of hours we have used and what is still available.
Thus far I have used a Bridge Flow to ads timestamps to requests and drive queue routing. To add the new auto approval function I started with by adding a Check Date\Time junction. The first value is pulled from the sheet row for a given request that triggered tot flow. Absence Date. It checks to see if this value is after a formatted version of the current date used earlier in the workflow. Format YYYY-MM-DD. If the Absence Date is greater than the formatted date is routes to a state listed as Review_Auto_Approve, if not it routs to state WFM_Review. Thus far this has worked exactly as desired.
Here is where I have run into a issue. I added a Search Sheet module to look up data in the sheet that has to day over day values. I set a row filter for a field in that sheet labeled date. I initially tried using the value of the absence date on the trigger row. Example 2026-03-31 but this returned a data: Array[0] result. I have tried reformatting the date and using the reformatted value as the filter criteria but still no data is returned.
Is this a functional limitation or something I am missing in my setup?
