Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Cell Change Counting

rozan.riggers27866

rozan.riggers27866 ✭

11/08/17 edited 12/09/19 in Archived 2017 Posts

Hello,

Is there a formula that will count the number of times a cell changes?

Thanks,

Rozan

Tags:

0 ·

Comments

Shaine Greenwood Employee

11/09/17

Hi Rozan,

There currently isn't a way to count the number of times a cell changes with a formula, or to use cell change history in formulas.

When you have a moment, submit a Product Enhancement Request using the form under Quick links on the right of the community site.

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Rolling-up information from sheet and reports. Unable to group information.
I am creating a report that pulls data from sheets and one other report. The information rolls up fine from both the sheets and report but it does not allow me to group the information from the report. For example, I want to group by program and then sub-group by sub-project. I keep getting a "Blank" for the group and the…
Need Help with a Formula
I'm trying to create a formula that says if the date in the "due date" column is between 60 and 90 days from today, mark yellow I've tried a few things but can't figure it out. Can anyone help?
Count the number of times a person's name appears in an "Assigned To" column
I currently use the below formula to count the number of times a name appears in the "Assigned To" column. The issue is that this column can have multiple names in the same cell, so I have to created a separate formula for every possible name combination. Is there a way to have a formula that looks for a name string and…