-
Today line on Gantt Chart
Is there any work around to make today line darker or more clear when gantt charts are printed?
-
Parent/Child/Ancestor Relationship to Referral Source, Client & Team Member
I am trying to make a relationship between the referral sources who have many referral agents in different counties who refer us clients which are handled by our team members. We track the clients compliance documents in smartsheets. The team member has a set of compliance information we track as welll. They are associated…
-
Vlookup
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
-
Index match returns a wrong value
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…
-
Automated Workflow Assistance - Recurring Monthly Notification off EOM Date
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…
-
Merged: Please allow access to create formulas from reports
This discussion has been merged.
-
Exporting Smartsheet calendar to Outlook 365
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…
-
Portfolio Template with Capacity Waterline Help
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…
-
Does smartsheet have the ability to track a resource's time at a milestone level?
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.