Hello -

I manage a library of hard drives at my company. I have set up the library list in Smartsheet. When an employee checks out a hard drive, I enter their name, email address and date of check-out to the hard drive row. I'm trying to figure out how to set-up an alert to automatically remind the

Hi, all.

I have recurring expenses monthly and it would be cool if I could have a new entry appear every month. Is there a way to do this?

Hi, whenever my boss tries to add me as a viewer to sheets we use to keep track of clients I never receive an email telling me the sheet was shared to me, and the sheet never shows up in my "shared to me" tab. I can't figure out why this is happening. On her end, it says that she shared it with me

I need to modify the following formula to include additional AND conditions.

=IF(Finished12 = 1, "Blue", IF(Target12 >= TODAY(+14), "Green", IF(AND(Target12 >= TODAY(+7), Target12 < TODAY(+14, "Yellow", IF(AND(Target12 < TODAY(+7),%COMPLETE>70, "Red"))))

The additional condition would be  in the

Hello,

We are using a form to RSVP to company events, for these events we have our team members inviting guests. The form is sent out by email to our team members and asks to provide their guest count, then we ask them to add their guest's contact info (name, company, email and phone number). 

The

HI, I've used pivot sheet to gather required information to show up in a sheet. I've attached a clip of the final result which works great except for the fact that I have formulas in some cells. When a new row is created, the formulas in the cells from above don't copy into the new cells. 

Can

I need to create a cross-sheet formula that counts the number of entries for a month and if there is text in another column. 

I've come up with the formula below, but I get an Incorrect Argument error:

=COUNTIFS({Review Month}, =1, ISTEXT({Critical 1}))

Where am I wrong

Hello,

Can I get some guidance on how to properly use Parent/Children formulas for a Summary sheet that is fed by information from a reference sheet?

I have several count ifs, and sum ifs all corresponding to the month and the year.  The parents and children will all have the same metrics and

Hello,

I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year. 

e.g.

| January |  45  |

---------------------

| February|  20 |

However, I am finding trouble actually calculating the amount based off of the

We are having a problem where accidental sorting occurs on a sheet used by several users, and I am looking to only allow users to enter data into a cell, but protect the placement of columns and rows.

In my research I can not see a way to do this, because it is my understanding that if a row is