Adjusting trip start/end date based on certain members holidays

rissa
rissa ✭✭
edited 12/09/19 in Smartsheet Basics

Hi everybody, 

 

I'm new to smartsheets and I'm not sure if there's a name for what I'm looking to do.

 

I volunteer for a small afforestation project in my local area. And want to make planning our planting trips a bit easier, as all our members are college students with varying schedules and holidays planned. (I already have it working to just print out available / unavailable)

But there are 2/3 members of the group that need to be present or we have to move the trip(the ones who own cars)

 

Referenced Sheet: Name, Vacation duration, Start Date, End Date, details

Current Sheet: Trip No, Location, Duration, Trip Start Date, Trip End Date, Attending(This is a contact list which allows multiple values but could be separated line by line if necessary)

Basically I was wondering if there is a way to do something like this in smart sheet or should I try another application for organizing, planning, project managing.

 

Basically I'm trying to do something like this

IF {Name Range} = [Name]1 AND (({Start date Range} >= [Trip Start Date]1) OR ({End Date Range} <= [Trip End Date]1) OR ({Start date Range} <= [Trip Start Date]1) OR ({End Date Range} >= [Trip End Date]1)) [if any vacations fall on/within planned planting trip dates basically]

THEN

{The duration of their vacation} + [Possible Start Date]

will output in a column called [Actual Start Date]

 

Is this possible in smartsheet? or am I better off using another application?

 

Any help is appreciated,

Thanks in advance,

Rissa

Comments