Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Try something like this...
="FY" + RIGHT(IF(MONTH([Finish Date]@row = 1, YEAR([Finish Date]@row), YEAR([Finish Date]@row) + 1), 2)
I have one sheet that houses all updates and comments for specific Releases (Sheet 1). I have a second sheet that lists every Release being worked on (Sheet 2). I am trying to pull only the most recent update from the Sheet 1 into Sheet 2. I am able to pull over an update when only using one criterion (either the Release…
I need help, please! I created a process that allows employees to request deactivation periods from their snow assignment. The ogranization allows for 5 employees for days and 5 employees from nights to deactivate at one time, per day. I am using the following formula to retrieve the number of slots available:…
Hello, I am looking for a formula that returns data if columns match in two different sheets I want to return the Trailer Number to sheet 1 from sheet 2 Sheet 1, Truck Tracker: Has column "Location" to match with the same column in Sheet 2. I want to return the Data from Column "Truck Number" (on sheet 2) to Column "Truck…
