Best Of

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.

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)

Hi @JoC

The answer to this question may apply to your case as well.😀

https://community.smartsheet.com/discussion/comment/404094#Comment_404094

"The workaround that worked for me is to copy rows manually first. You can use the normal sheet and workspace directory in the manual "Copy to Another Sheet" dialog panel. Then, when you go back to the workflow, you can search the sheet, and it will pop up as candidates."

Another way I often try is to shorten the entire name of the sheet by a couple of characters. For example, if the sheet's name is "Move or Copy Rows", I try the search by "Move or Copy Ro".

@NBKD

There is a slightly different formula:

=IF(Complexity@row = "Low Complexity", WORKDAY([Record Date: Complexity]@row, 2), IF(Complexity@row = "Medium Complexity", WORKDAY([Record Date: Complexity]@row, 5), IF(Complexity@row = "Most Complex", WORKDAY([Record Date: Complexity]@row, 10))))

Note that you can also populate an earlier date using the WORKDAY function -- just put in a negative number of workdays instead of positive.

Hi @Mike S. & @Debbie Sawyer

Thank you for all of your detail on this thread! Based on this information, I've been able to reproduce this if the only daily change is happening in the Summary Panel as well.

Here's a metric widget that should show Thursday:

All of my other sheets/tests (same as Debbie) are working as expected since the grid of the sheet is being changed. I believe this may be expected, however if it used to work for you then I'll follow-up with our Support team as well to see if there have been any changes recently. If this is expected, we'll update the Help Article to note that changes need to happen in the Grid, not in the Summary panel.

In the meantime, I would suggest using a hidden helper column in your sheets instead of using a Summary field.

Thanks!

Genevieve