Backtracking Formula Origination - "Cost#"

r0030

Has anyone ever used or seen "Cost#" used in a formula? I'm not sure what it's referencing, but it doesn't look like anything specific to my sheet.

Any insight is greatly appreciated!

Shimanta Roy

@rmc0030 the "Cost#" part in your formula actually specific to your sheet. It is coming from the sheet summary. Someone else has created a sheet summary field named "Cost". You can check it by clicking on the sheet summary icon on the right most panel of the sheet as I have marked below. You can use sheet summary fields in any of your formulas by using # sign. For single word field name just put a # after the field name. For multi words field name, use [ ] as well. For example, [Sheet summary field name]#

Shimanta Roy

@rmc0030 the "Cost#" part in your formula actually specific to your sheet. It is coming from the sheet summary. Someone else has created a sheet summary field named "Cost". You can check it by clicking on the sheet summary icon on the right most panel of the sheet as I have marked below. You can use sheet summary fields in any of your formulas by using # sign. For single word field name just put a # after the field name. For multi words field name, use [ ] as well. For example, [Sheet summary field name]#

r0030

Ahh, that's it! Thank you so much, Shimanta!