Formula to count number of task

Hi,

I need help with adding a formulat to count the number of task. I tried adding the formula but it didn't count the task it adds it to the number of task for the above row. I'm fairly new to smartsheet so it's taking me a minute to figure out the formulas. Any help will be great appreciated.

This is the formula I used.

="# of Grants May - " + COUNT(CHILDREN())

Thank you

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

LCallier

I need to calculate the # of Grants we have per month. Row 23 will be the # of grants we have for the month of May. When I entered the task for May it didn't calculate on Row 23 it added the # of grants to the # of grants for April. I have attached an example of what I am referring to and how it should be. Thanks for taking the time to help.

https://app.smartsheet.com/sheets/pjChV4CRmQqpj8X8RMG85WGQvc4jCH3rmXj86Vc1?view=grid

Upcoming Grant Applications Example.jpg

Debbie Sawyer

Row 23 is indented (so it is a child of April)

Click on the data in Funding Mechanism Row 23 and press your Outdent button (7th button on your toolbar (next to the Filter button)). This will change your formula and May will behave again.

Kind regards

Debbie Sawyer Consultant & Training Manager

debbie.sawyer@smarterbusinessprocesses.com

Andrée Starå

Happy to help!

I'll take a look and get back to you!

Best,

Andrée

Andrée Starå

I saw that Debbie found and answered what was wrong!

Let me know if I can help with anything else!

Best,

Andrée

LCallier

That worked!! Thank you so much!

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…