what is the best way to look up between smartsheets and keep the data fresh =VLOOKUP([Equipment ID]@row, {Equipment Tracker H5 RM 8.8.24}, 1, false) Equipment ID]@row = equipment id this sheet {Equipment Tracker H5 RM 8.8.24} = large data block in another sheet this works but will not refresh if data changes help
Anyone able to help with an Index/match formula that returns a wrong value? We've a formula that is returning a wrong value. I believe the formula is correct (it's the same way I write it in .xls). We are referencing another Smartsheet in the formula. I understand if I was getting an error (#invalid value, #No match), but…
I came across many articles regarding connection from Smartsheet to GIS, but I'm interested in getting attributes out of GIS and into Smartsheet. We have many program administrators need information from GIS and manipulate it to create and track projects.
Hi Smartsheet community! Here's the challenge I'm running into: a leader has asked me to set up a recurring a monthly notification, triggered off the last day of month, for the team to update their monthly forecast within following three days. I have a parent of "Expense Input for Monthly Forecast" and child rows of…
This discussion has been merged.
I'm struggling to export Smartsheet Information into Outlook 365 calendar. I'm trying to create a group calendar specific to resources(people) assigned to task(s) within my SmartSheet schedules so to have each individual assigned to a Smartsheet task in order to get an overall view of each persons time spend on multiple…
I'm thinking of transitioning my current project portfolio to this template that includes a capacity waterline but I'm having trouble getting started. Usually the templates include a guide on where to start and how the data flows between the sheets, reports, and dashboards but I can't find it for this one. Thanks in…
I am trying to see if this functionality exists or if this is an enhancement that can be created? This would allow the ability to report on specific activities instead of at a project level.
Hello there! How do I automate or create formulas to predict start and end dates for a project plan / timeline in Grid view? We have four stages - Planning and 3 to 4 different Creative Asset delivery dates for 4 departments. Look forward to your guidance here!
