Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am trying to figure out the best way to handle that. Would I only

In Sheet One, there are 25 products assigned to 4 Product Types. Each Product has an expected delivery and an actual delivery date.

In Sheet Two, we want to add the dates associated with the percentage complete.

The existing formulas provide the percentages and totals but how can I add the dates for

I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met.

Sheet One displays the Sales Reps for New and Modified Items:

I want to display the Item Rep for NEW item types.

The formula entered on Sheet Two is:

=IF(AND(MATCH(Item1, {SHEET ONE_ITEM}, 0),

We have been using this formula to add up the hours spent working specific clients -- been working fine. We have also been asking what category of work they have been completing at these clients but haven't been utilizing the data.

=SUMIF({Kinsman - Job#1}, [Scope of Work]@row, {Kinsman - Hours#1})

I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to

Hi,

I have a sheet for an event we are running and I want to flag any row that has been modified in the last 72 hours (3 days).

Right now I have a flag column and a hidden modified date column.

Any help with the formula please?

Thank you!

Hi! I am trying to find a formula to check a box Done when several other cells are checked done.

My If Then formula doesn't seem to work. Any thoughts?

=IF([Column2]1 = "Done", 1,

I am working on a sheet and want to incorporate an IF (or maybe an IF AND) statement based on the date items are submitted to them for review, which is one of the date columns in the sheet.

Here are the conditions I want to test:

1) If today is less than or equal to 3 weeks from the submission

Hi,

I am wondering is there a way to have an auto numbering column where the display format is dependant on the value of another column.

I have a "Type" column that is a dropdown with "Action" and "Decision" as the values. I would like the Auto number to display A-001 if this column is "Action" and

I'm trying to come up with the formula to dropdown only certain countries if chose certain region.

I have two dropdown columns Region and Country

If chose Region EMEA, country dropdown list will show DE, DK, NO

If chose Region APAC, country dropdown list will show JP, SG, IN

If chose Region AMER,