Need to default a column to a specific value after row is copied to another Sheet

Good day,

I have a sheet that is used for tracking visitors, at the end of each day all rows in the sheet get copied to another sheet that is used for metrics. Once all the rows are copied I want to set a column to zero so that it can be changed to a value for the next days work.

I have created an automated workflow to do the copy rows to a metrics sheet but cannot figure out how to set the column values for all rows to zero and still allow the cells to be updated.

I have tried using a column formula however that does not allow you to change the cell value

Here is a view of my main sheet the red arrow is the column I am trying to default to zero

Here is my workflow

appreciate the help

Find more posts tagged with

Accepted answers

Andrée Starå

@bday2329

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi @bday2329

I hope you're well and safe!

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

As a possible workaround, you could.

Use a 3rd party solution like Zapier
Use the Smartsheet API
Move the rows to the other sheet instead and then have a default structure in another so-called helper sheet that copies it over to the main sheet to set the values to 0 again.

Would any of those options work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

bday2329

Thanks Andree I submitted an enhancement request

Andrée Starå

@bday2329

Excellent!

You're more than welcome!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.