Welcome!

SUMIF Formula returning 'O'

I'm using the following formula to sum invoice amounts, but its returning '0's

=SUMIF([Job #]$6:[Job #]$60, [Job #]62, [Current Amount Due]$6:[Current Amount Due]$60)

I have also tried

=SUMIF([Job #]$6:[Job #]$60, "18-030", [Current Amount Due]$6:[Current Amount Due]$60)

I was able to figure out the issue. The Job# for the invoice data had a period and the job numbers where I was totaling had a dash.

Is it a bug? "Removing user Access" by clicking X - works sometime and then it does not.
Hi everyone, I'm the owner of worksheet/workspace and am currently unable to reliably remove user access through the "Manage Access" panel. This issue just started occurring recently. The Problem: When I click the "X" next to a user's name to remove them, it works for the first user. For any subsequent user, the "X"…
Can one cell change cause workflows in multiple grids?
I'm trying to move data from two grids (Grid #1 and Grid #2) using workflows (When rows are changed) to archive grids when a cell is ONLY updated on Grid #1. Here is my setup and what the issue I'm having… Grid #1 has the column that is being updated. Workflow setup on Grid #1 to move the row when the cell is changed to a…
Slow loading
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑