# Emma_w4tevr’s Profile

points
44

Hi Again,

After scouring discussion boards I have managed to Average the total of the rows, see below

=IF((COUNT([Days to respond]194:[Days to respond]214)) = (COUNTIF([Days to respond]194:[Days to respond]214, 0)), 0, SUM([Days to respond]194:[Days to respond]214) / ((COUNT([Days to

The subject pretty well tells it all,

I am trying to sum the network days between the request received and request sent date but if we haven't sent the request response as yet the field is empty and shows the error " Invalid data type"

Current sum is

=NETWORKDAYS([Quote Request Recieved]198, [Quote

Hello,

I am trying to created a multiple if Statement.

If column1 contains "Milestone 1" show "30% invoiced

If column1 contains "Milestone 2" show 80% invoiced

If column1 contains "Milestone 2" show 100% invoiced

Hello,

I am trying to Check box = If column 1 ="x" and if column 2 is checked = column 3 to be checked

e.g. If Column 1 contains "Street Lighting" & Quote Successful Column is checked, Street Lighting successful box is checked

I've tried the following equasions

=IF(AND(Team7 = "Street Lighting",

I keep getting the result of 0

I am trying to sum a range if another column contains "Street Lighting"

I have tried changing the text reference from the entire column, to particular range and adding the LEFT @cell with and without #(5) see below.

=SUMIF(Team:Team, LEFT(="Street Lighting", [Days to

Cant get my formula to work =(

=IF(AND([Team]28 = "Street Lighting", (NOT(ISBLANK([Quote Sent Date]28)), 1, 0)))

If Column 1 (Team) contains text "Street Lighting" and Column 2 (Quote sent date) is not blank, Check the box

Thank you in

Hi All,

Still new to SmartSheet so help would be appreciated

I am trying to sum a column if another column contains specific text "street lighting"

I have come to

=COUNTIF(Team:Team, "Street Lighting," ([Past Due Date]:[Past Due Date])

but it comes back with Unparseable and I am lost, It's