Automatic workflow not working
我想设置up a recurring date to be entered into the sheet using automatic workflow (photos enclosed)
I want to be able to type in "blah blah blah" into the event name column and have it repeat every month on the the third sunday.
What am I doing wrong?
Answers
-
Jeff Reisman ✭✭✭✭✭✭Can you give us more information, maybe show your entire trigger? Your pictures don't really jive with your description:
我想设置up a recurring date to be entered into the sheet using automatic workflow (photos enclosed) I want to be able to type in "blah blah blah" into the event name column and have it repeat every month on the the third sunday. What am I doing wrong?
It looks like your triggering this on the first Wednesday of the month starting on ? to look for rows where Event Name = blah blah blah, and to then set the values of those other cells. However your description says you want a recurring date to be entered into the sheet.
Regards,
Jeff Reisman,IT Business Analyst & Project Coordinator,Mitsubishi Electric Trane US
链接:Smartsheet Functions Help Pages链接:Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
renogawj ✭More information on the event. Apparently, it's every Sunday from May until November from 0700 to 1400. We want to be able to enter it on the smart sheet with all the information once and have the recurrence show up on subsequent dates. I think I got into the weeds a little with my pictures
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/86754/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/86754/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/G1SDKXPQ7I1D\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/GCQ7U05Q4GNO\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/79GD9D2EWXCW\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
