Best Of

Hi @FTesseneer,

We have a similar thing when a user submits a IT ticket, sometimes it needs to go to two separate sub-teams to action, in this instance we have two automations that run when a row is added or when a specific field changes to send notifications to each of the teams, those Update Requests then contain different fields depending on the team that they are sent to.

Hope this helps!

John

You're absolutely right that update requests should appear in the request log, even if they are sent to external suppliers who are not part of your company. However, there are a few reasons why they might not show up as expected:

• The row-level update request icon (envelope) only appears if the request is still pending.

• If the supplier submitted the update, the icon disappears, and the request is no longer listed as pending.

• You can still view the cell history to confirm changes made via the request.

• If the email address is incorrect or the user is deactivated, Smartsheet may not log the request properly.

• External users do not need a Smartsheet account, but the email must be valid.

If your organization has SSO or MFA policies for external collaborators, the request may not be delivered or logged unless the recipient complies.

• If the update request is triggered via automation, check that the workflow allows sending to unshared users.

• Go to Automation > Manage Workflows > Gear Icon and ensure “Unrestricted” is selected under notification permissions.

I agree with @TVang about if using TODAY()

I, as a standard on every smartsheet, have an automation that runs every morning about 1am that saves today's date in a helper field I've called Analysis Date.

This updates my smartsheet every morning and makes sure it knows what Today is

This keeps all my formula in the smartsheet and any automations that are date & time triggered up to date and current. Otherwise the smartsheet is "asleep" until a record gets updated.

I was given this awesome advice several years ago and solved several issues that initially seemed totally unrelated.

Good luck

Hi @Katelyn Birdsey

As I tested, the SUMIF method did not work because the SUM({Checkbox Column Range}) returned 0.

My solution is similar to Jgorsich's in that it uses multiple reviewer-submission reference pairs, but it uses the COUNTIFS function.

I guess the value of a Boolean column, like a checkbox, is 'true', and summing will return 0. In some cases, replacing 'true' with '1' works, but not in this case.

https://app.smartsheet.com/b/publish?EQBCT=c2821923195f435497dfc6f800ff81ca

In the formula, I used nine reviewer-submission reference pairs, for a total of 18.

[Completed]
=IF(ISTEXT(Reviewer@row), 
  COUNTIFS({Students : Reviewer 1}, Reviewer@row, {Students : Reviewer 1 Submission}, true) + 
  COUNTIFS({Students : Reviewer 2}, Reviewer@row, {Students : Reviewer 2 Submission}, true) + 
  COUNTIFS({Students : Reviewer 3}, Reviewer@row, {Students : Reviewer 3 Submission}, true) + 
  COUNTIFS({Faculty : Reviewer 1}, Reviewer@row, {Faculty : Reviewer 1 Submission}, true) + 
  COUNTIFS({Faculty : Reviewer 2}, Reviewer@row, {Faculty : Reviewer 2 Submission}, true) + 
  COUNTIFS({Faculty : Reviewer 3}, Reviewer@row, {Faculty : Reviewer 3 Submission}, true) + 
  COUNTIFS({Scholarships : Reviewer 1}, Reviewer@row, {Scholarships : Reviewer 1 Submission}, true) + 
  COUNTIFS({Scholarships : Reviewer 2}, Reviewer@row, {Scholarships : Reviewer 2 Submission}, true) + 
  COUNTIFS({Scholarships : Reviewer 3}, Reviewer@row, {Scholarships : Reviewer 3 Submission}, true))

For example, regarding the student-reviewer-submission pairs, I created the two cross-sheet references, as shown below.

Below are the sample sheets for this demo solution.

https://app.smartsheet.com/b/publish?EQBCT=877c1bc84c2e4b03a58c47e21117ff7f

https://app.smartsheet.com/b/publish?EQBCT=eb349913c1694b7b9215f5d731672b83

https://app.smartsheet.com/b/publish?EQBCT=a41c380731b14aaea5e06bae6787e51c

P/S

I also created a solution to retrieve the Reviewer values from those sheets automatically.

https://app.smartsheet.com/b/publish?EQBCT=20ac30cdb61e4bcbb066f31d9665e842

First, I created a helper sheet, 'All reviewers', to get all the distinct reviewer names from those three sheets.

[No.]
=MATCH([Row ID]@row, COLLECT([Row ID]:[Row ID], Sheet:Sheet, Sheet@row))

[Reviewer Contact]
=IFERROR(
  IF(Sheet@row = "Students", INDEX(DISTINCT({Students Range 1-3}), [No.]@row), 
  IF(Sheet@row = "Faculty", INDEX(DISTINCT({Faculty Range 1-3}), [No.]@row), 
  IF(Sheet@row = "Scholarships", INDEX(DISTINCT({Scholarships Range 1-3}), [No.]@row)
))), "")

Then, I use the names to populate them in the first sheet with the following formula;

=IFERROR(INDEX(DISTINCT({All Reviewer : Reviewer Text}), [No.]@row), "")

@maineL, if you're using the TODAY() function in the [Today's Date] column, then consider using a different column as the trigger. The reason is that TODAY() is not calculated until the sheet is opened and saved. In other words, [Today's Date] is blank at the time the new row is created and the workflow is triggered.

Use the auto number column if you have that in the sheet. This field/column will always contain a value.

Cheers!

Ooo!! Good point, while playing around with this in a scratch sheet I got this notification:

Are your permissions set to allow anyone to get that email? (Do you get the email if you test it with your name in the "alert" box/)