 # Tribeiro’s Profile

points
26 how can I add IFERROR to this formula

=WORKDAY([Start Date]140, 15)

I tried =IFERROR(WORKDAY([Start Date]140, 15, ""))

and it didnt how can I count specific open ports that are separated by a comma? How can I count how many projects were completed in 2018 and 2019?

I am trying to create a graph for all projects completed in 2018 and 2019

this is what I got so far. I am pulling data from another smartsheet.

=COUNTIF({Completed Range 3}, "Completed" + {Completed Range 2} = DATE(2019))

Thank you how can I exclude N/A on the count if N/A is selected

Formula:

=COUNTIF(CHILDREN(), "Done") + "/" + COUNT(CHILDREN()) + " (" + ROUND(COUNTIF(CHILDREN(), "Done") / COUNT(CHILDREN()) * 100) + I'm trying to convert an excel formula to use in smartsheet without much success.

The excel formula is:

=IFERROR(MATCH(\$F4,'Lookup Table'!\$B\$3:\$B\$7,0)*MATCH(\$G4,'Lookup Table'!\$B\$3:\$B\$7,0),"")

In short, I need the 'Risk Matrix' column in smartsheet to show the score where the probability and impact How do I indicate that I would like to count any time the cell has "DESIGN" in it whether the cell says exactly "DESIGN" or Hello,

I'm trying to create a monthly report from quarterly data. I want a formula that will count how many projects went live in a given month from a column of dates. In the screen shot, I want to put a formula in the blue cell that tallies the Actual Live Date column.

Thoughts? Thanks! Need a 'countif' example, where cell contains a