-
How to add multiple IF statements to WORKDAY function?
Hello trying to add multiple cities to a workday function. This is to subtract our ship day from the expected arrive by date. Currently, this is what I have =WORKDAY(F3,IF(OR(K3="CITY1",K3="CITY2),"-2","-10"),Sheet1!B$2:B$49) I want to add 2 more cities. The function can either be from another column/sheet that has the…
-
Assign Workflow issue
I think I've been looking at this for too long and I need help! I received this message "We had additional conditions set up that didn't show disabled, but wouldn't assign on this workflow so we changed them to be OR and apparently it still isn't assigning but isn't showing as broken either" In the attached picture, is…
-
Automated Workflows with multiple actions are not working
I have an automated workflow set to trigger anytime the value of a cell in a specific column changed. The workflow has 2 actions: Notify a Specific Person (me) and Change the Value of a Cell (In this case, it is a the cell is a checkbox and I want to set the value to checked. The workflow is sending me notifications when…
-
Does anyone else have trouble with attachments missing from email notifications within a workflow?
We use smartsheet for electronic applications. Once a new application is submitted, we generate documents, and check a box which triggers our workflow. It is supposed to include attachments, but sometimes it is missing. Does anyone happen to have a solution for this?
-
Workflow Copying - Entire Columns
Hello Experts, I am writing a workflow to copy and paste a particular Column value from 1 sheet to another sheet. However, the workflow is copying the entire column details from the spreadsheet.
-
Notification Trigger 44 Weeks After Date
Hello, I'm trying to set up an automatic notification for training reminders without using helper columns. I'd like to set up the trigger date as 335 days after a specific date (4 weeks before they need to renew). For example, if they renewed their training on September 28, 2020 then they would get a reminder notice on…
-
Simple change cell workflow not working
Hi, I have created a very simple workflow to change a cell (check a checkbox) when a status changes to "Complete." It is not working. I've had the same problems with similar workflows - (Add text to a notes field when a status has been changed). Am I missing something?
-
Workflow to be triggered when cell is changed to specific value
Hi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!
-
workflow to be triggered when cell is changed to specific value
Hi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!
-
Reminder Workflow
Hi there ; İ would like to get your advices about below issue ; I want to set a workflow that system will remind a row every 15 th of workday of each month.How can i set trigger on workflow for it ? Thanks in advance for your kind replies Erhan