SOLVED
Home

Sharepoint calculated column help- absolute values?

%3CLINGO-SUB%20id%3D%22lingo-sub-1052661%22%20slang%3D%22en-US%22%3ESharepoint%20calculated%20column%20help-%20absolute%20values%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1052661%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20calculated%20value%20in%20my%20SharePoint%20list%2C%20based%20on%202%20other%20columns%3B%20in%20a%20previous%20excel%20document%20I%20have%20used%3A%3C%2FP%3E%3CP%3E%3DIF(%5B%40%5BResponse%20On%20Time%5D%5D%3D%24AV%242%2C%22On%20Target%22%2CIF(%5B%40%5BRevised%20Response%20On%20Time%5D%5D%3D%24AV%242%2C%22Within%20Extension%22%2CIF(%5B%40%5BRevised%20Response%20On%20Time%5D%5D%3D%24AV%243%2C%22Out%20of%20Target%22%2C%22Out%20Of%20Target%22)))%3C%2FP%3E%3CP%3Ebut%20that%20was%20using%20absolute%20values.%20I%20can't%20see%20any%20way%20of%20creating%20absolute%20values%20anywhere%20in%20the%20SharePoint%20list%20to%20refer%20to%2C%20but%20do%20I%20actually%20need%20to%3F%20Can%20I%20not%20just%20change%20the%20absolute%20value%20reference%20(%24AV%242)%20to%20a%20Yes%2FNo%20as%20specified%20in%20the%20columns%20i'm%20using-%20why%20won't%20that%20work%3F%20It%20won't%2C%20i've%20obviously%20tried%20it%2C%20but%20I%20don't%20understand%20why%2C%20or%20where%20i'm%20going%20wrong%20with%20the%20whole%20thing.%20Any%20help%20would%20be%20gratefully%20received%2C%20thank%20you!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1052661%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1053245%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20calculated%20column%20help-%20absolute%20values%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1053245%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F457891%22%20target%3D%22_blank%22%3E%40carmelowen2105%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3ECan%20I%20not%20just%20change%20the%20absolute%20value%20reference%20(%24AV%242)%20to%20a%20Yes%2FNo%20as%20specified%20in%20the%20columns%20i'm%20using-%20why%20won't%20that%20work%3F%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20you%20can.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20an%20example%20that%20I%20used%20recently%3A%3C%2FP%3E%3CP%3E%3CEM%3E%3DIF(Priority%3D%22Low%22%2CCreated%2B7%2CIF(Priority%3D%22Medium%22%2CCreated%2B14%2CIF(Priority%3D%22High%22%2CCreated%2B21%2CCreated)))%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20reference%20this%20site%20whenever%20I%20am%20creating%20calculated%20columns%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FExamples-of-common-formulas-in-SharePoint-Lists-D81F5F21-2B4E-45CE-B170-BF7EBF6988B3%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FExamples-of-common-formulas-in-SharePoint-Lists-D81F5F21-2B4E-45CE-B170-BF7EBF6988B3%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055834%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20calculated%20column%20help-%20absolute%20values%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055834%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20has%20helped%20a%20lot%2C%20thank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
carmelowen2105
New Contributor

Hi, 

I want to create a calculated value in my SharePoint list, based on 2 other columns; in a previous excel document I have used:

=IF([@[Response On Time]]=$AV$2,"On Target",IF([@[Revised Response On Time]]=$AV$2,"Within Extension",IF([@[Revised Response On Time]]=$AV$3,"Out of Target","Out Of Target")))

but that was using absolute values. I can't see any way of creating absolute values anywhere in the SharePoint list to refer to, but do I actually need to? Can I not just change the absolute value reference ($AV$2) to a Yes/No as specified in the columns i'm using- why won't that work? It won't, i've obviously tried it, but I don't understand why, or where i'm going wrong with the whole thing. Any help would be gratefully received, thank you! 

2 Replies
Solution

Hi @carmelowen2105,

 

Can I not just change the absolute value reference ($AV$2) to a Yes/No as specified in the columns i'm using- why won't that work?

 

Yes you can.

 

Here is an example that I used recently:

=IF(Priority="Low",Created+7,IF(Priority="Medium",Created+14,IF(Priority="High",Created+21,Created)))

 

I reference this site whenever I am creating calculated columns - https://support.office.com/en-us/article/Examples-of-common-formulas-in-SharePoint-Lists-D81F5F21-2B...

 

I hope this helps.

 

Norm

That has helped a lot, thank you @Norman Young