Best Of
Re: Why would a formula work on one sheet but be #unparseable on another?
Hi There,
I just figured this out this morning. I did not have the Category column correct.
Thank you for responding,
Lori
Lori C
Re: Automation Deleted, Messages Continue.
Try to check if there's an identical workflow that is causing the alerts. If not, you can raise a support ticket to identify the root cause.
AravindGP
Re: Automation Email Alert Issue - Grouping Notifications with Unique Subjects
Ok @Jeremy W., here's what I did:
I had an "auto number" column in my sheet already, and it counts by one and assigns a new number to each row. What I added for my solution was an Alert ID column that, with a formula, just pulls the right final digit from the auto-number column, so I've ended up with a column that has the single digits 0 thru 9.
Then, in my automations, I simply duplicated my alert 10 times and added a conditional filter to each one to send if the Alert ID is equal to 1, using a different number for each of my duplicated alerts.
I believe this will result in Alerts only being combined if two rows are updated at the same time AND there are 9 rows between the two rows that are being updated. This should greatly reduce the risk of combined alert emails for my specific situation, since I have very few updates happening as the entries age.
If you have a lot of rows being updated daily, you may be able to break them up in a similar way, but using a different identifier that would give you a span 20 or 30.
One drawback is if I need to update the custom message, now I have to do it 10 times. 😕
Re: Calculating Duration Between Two Dates
So i was able to figure it out using another post on here by using the formula below.
For Net Work Days
=Networkdays([start date]1, [end date]1)
I was using duration and predecessors incorrectly and it was throwing off my sheet. The formula above helped my calculate just the difference in days I was looking for and then it properly calculated on my reference sheet. Thanks for the reply I just figured it out so I'll be closing it out.
Be aware of new Smartsheet invitation email experience
Hi Community,
Several customers reported that in the last month, the invitation emails sent to their users to join their organizations’ plans were being automatically declined. Upon investigation, we concluded that this behavior was caused by customers’ email security software that uses “link inspection” which automatically clicks links to check for security threats. During this process the Decline link in the invite emails were being inspected and “clicked” which caused Smartsheet to believe that the user had declined the request, when in actuality the user likely hadn’t even seen the invite yet.
Since we cannot control the behavior of email security software, our Engineering team has temporarily modified the invitation process until a longer term solution can be developed. This is why invitation emails are now directing users to the Smartsheet login page. We’ve also updated our Help Center Article “What to do when you receive an invitation to join a Smartsheet account” to reflect this change.
When you invite a user to join your organization, they will receive an email invitation from user@smartsheet.com. Once they select either Accept or Decline in the invitation email, they will be directed to the Smartsheet login page.
- If the recipient has previously logged into Smartsheet, they will need to log in with their email and password to review the invitation.
- If the recipient has never logged into Smartsheet, a new account is created and they will need to set a password for their new login.
- In order to set a password, they will need to select the Reset Password link on the login page which will generate an email with a link to set a password in Smartsheet.
- Once logged in, they will be prompted with the invite options and can Accept or Decline the invitation as usual.
Please note: If you have users who are currently Declined, a SysAdmin will need to resend the invitation email using Admin Center. To resend the invitation, please locate the users in the Admin Center, click on the 3 dot menu to the right of their email address and select Resend Invite Email or re-invite through the bulk user invite method.
This impacts users in all plans. Please read this help article for more details.
You can also stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Best regards,
The Smartsheet Product Team
Lekshmi Unnithan
Re: Why would a formula work on one sheet but be #unparseable on another?
Is the Category column in your new sheet the same column type as the Category column in your old sheet?
Re: Help using the NOT formula
This should work for you...
=COUNTIFS([PM Resourcing Score]:[PM Resourcing Score], >=8, [Approval Status]:[Approval Status], NOT(CONTAINS("Canceled by Specialist Team", @cell)))
Re: Why would a formula work on one sheet but be #unparseable on another?
Hi Lori,
It's possible that the sheet references weren't transferred when you setup your new sheet. You can check this quickly by right clicking any cell and selecting "Manage References...". If you don't see your reference names there (e.g. {Rounding| Number of Staff Contacts}), then you'll have to setup those references again in the new sheet.
I hope this was helpful!
Re: Cross Referencing and sum formula
Oh, your issue is that you need to change the errors to match with the agent, and also change the logic of the IF.
So now we have:
=IF(agent@row = "", "", SUMIFS({Errors Range}, {Agent}, agent@row))
So, if agent is blank, blank returns. If agent is not blank, SUMIFS function occurs to tally the errors range based on the {agent reference} matching with agent@row.
SteyJ
Re: Want a column to autopopulate parent taskname
Hey @Corey McCarren
Good, I'm glad you figured out to insert your primary column. Instead of using the specific row number, use @row so that it remains a dynamic reference.
=PARENT([Task Name]@row)
Kelly Moore

