Brittanie_Ander - profile

Brittanie_Ander · Mar 12, 2020

I have a formula for calculating when I can plant seeds, according to the LFD (last frost date), which is and will remain 3/29/2020. Weeks is how many weeks before the LFD I can plant the seeds. The formula: DATEADD({LFD},-{Weeks Start},‘weeks’) Curr...

Brittanie_Ander · Mar 12, 2020

I have a formula to calculate how many plants I can fit in a 10x12" square. My formula goes: 10/Spacing * 12/Spacing. (Spacing is a column where I record the number of inches of distance a plant needs). The formula works, except for in two instances-...

Brittanie_Ander · Mar 12, 2020

Thank you! That completely solved it! What does DATESTR stand for? I kept trying to put in different formats of 03-29-2020 with no luck, so I made that unnecessary column for it. I had no idea about DATESTR.

Brittanie_Ander · Mar 12, 2020

Hi, thanks for answering. Would you mind showing me how to apply your response to my example? I’m new to this and I read over what you wrote a few times but I don’t understand how to apply it to my issue at all. Ideally, I would like to find a way to...

Brittanie_Ander · Mar 12, 2020

Thank you. Removing the quotes fixed it!

Brittanie_Ander · Mar 12, 2020

Thank you! Everything worked except for now the Formula itself is displaying as a long string of decimals and it is saying “Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or...

User Statistics

User Activity

Can a formula reference one cell instead of a column?

Please help with basic formula producing Infinity & the wrong count

Re: Can a formula reference one cell instead of a column?

Re: Can a formula reference one cell instead of a column?

Re: Please help with basic formula producing Infinity & the wrong count

Re: Please help with basic formula producing Infinity & the wrong count