Hi,

I have a series of standard processes that have the same dependency and predecessor data each time. 

I have the primary column  as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.).

If pre-assembly is selected, for

I have created a smartsheet that contains a form for my team to fill out. Once this form is filled out I would like that data to go to the main sheet that is viewable by my team and then populate another sheet that is viewable to the managers only. Is there a way to have that data when added to

I need to color a ball yellow if the value in a column is between .05 and .15. If the value in the same column is greater than .15 OR a checkbox is selected, I need the ball to be red. Not sure how to accomplish this. Appreciate your help.

Hi everyone,

I have a question about the range name and description.

When I use formula with another sheet it calls automatically like {range Count}.

Later, when I try to find out, which sheet data is being used in the formula, I can't find the sheet and range because I just forgot it and it is not

Hi All,

I've been having a lot of trouble with a vlookup formula that I have linking a sheet with ALOT of columns--just under 200. There seems to be a  limit to the number of columns to 'look at' (which is 85.) This is the last formula that I have which works. 

=VLOOKUP(TODAY(), {1. DOR (Pull-out)

I'm attempting to set up conditional formatting to highlight cells if there are duplicate dates in the same column. (For a spreadsheet managing event bookings, want to highlight if multiple requests for same day)

I tried an IF/COUNTIF function in a new checkbox column but I keep getting

I tried to count all parents inside a sheet but since now it was only possible with an additional column.

The formula I used to check if it was a parent is this one: =IF(COUNT(PARENT([Task Name]2)) > 0, "false", "true")

And to calculate how many parents are existing, I just counted the cells,

I have a grid where I am trying to lookup from a grid that people can log issues on. The first lookup is the date range, we want to count all issues within that date range. Then we only want to count by the "Field". On the log it is the column titled Field it is a dropdown of those fields listed on

Hi!

I'm trying to create a formula that will count the number of rows that have a "Delivery Date" after 1/1/2019. Any row with a date prior to that should not be counted. I also do not want blank rows counted.

In the screen capture attached, you'll see all but one populated row should be counted.

I have a sheet where issues are logged. The primary is a record ID, I have another column "Assigned" which has 7 names in a dropdown. Another column is "Field" with 9 options in a dropdown. I am trying to create a formula that will lookup unique pairs from Assigned and Filed and count the number of