JamesB
JamesB
Reactions
-
Re: How do I create a formula to pull the year from a date from every row in a column?
@kelsey_odoc Use the formula's below in your month and year columns and make them column formulas. These will be Text/Number columns. =YEAR([Date of Employee Request]@row) =MONTH([Date of Employee Re…1 · -
Re: Duplicates formula
@Jimena you can do this in conditional formatting.1 · -
Re: Forms
@Stacey M Forms submit into the sheet where the form is created from. You will need to refresh your sheet when a form is submitted so you can get the latest information from the DB.1 · -
Re: SUMIFS with Date Range & Condition
@Chloe MB When writing a SUMIFS, the first argument is what to sum, then range, then criterion. I think based on the formula above, you would want to adjust it to read this way. =SUMIFS([Quote Total]…1 · -
Re: How Can I Multiply 2 fields and then divide in 1/2?
@Adrian B This should do what you want. =SUM(([Hotel Rate Double]@row * Tax@row) + [Hotel Rate Double]@row) / 21 ·
