Best method to update a project sheet

Ahmed Lazrak
edited 12/09/19 in Smartsheet Basics

Hello everyone!

I'm a project coordinator at a company specialized in manufacturing and installing irrigation systems, we have over 50 projects going on at the same time.

We're trying Smartsheet to check whether it suits our needs, we're looking for a way to let a user supervising the project to update the progress (%Complete) and indicate if there's an urgent situation (At Risk?) in the project sheet.

I've tried forms but the they only add new rows of data and can't update existing rows.

I've also tried using reports but the user has to have access to the original sheet and we want to avoid that because it contains financial data too.

is any workaround or a better method for doing this? 

Many thanks in advance