-1
votes
0answers
25 views

Calculated Field - Based on Drop-Down Field, Populate Multiple Lines of Text Field

We have a list that looks like this: **ID # File Name Confidential Redact** 001 XXX_SOC Confidential We need to have the redacted multiple lines of text field auto-populate ...
0
votes
1answer
49 views

Calculated column: Lookup

Say I have a Date/Time [Date] column and a numerical [Value] column. I am creating a calculated column. I need a formula that will find the row with the most recent date in the [Date] column, then ...
0
votes
1answer
72 views

Calculated field with images and multi-value column

Say I have this list that looks like this: Title Link ----- ----- Cat /animals/cats.aspx Dog /animals/dogs.aspx Duck ...
0
votes
1answer
112 views

Set current date i.e [Today] in a list column

I have a requirement where in user wants a column to be populated with Current date i.e Today. I went through many posts and found it is not possible to use Today() in list columns. The reason why ...
1
vote
3answers
728 views

Dynamically hide column list item if the field is empty

I have a series of fields that I would like NOT to appear in my list dispForm.aspx. So when a user creates a new list item if these fields are unpopulated the do not appear DispForm.aspx but I still ...
0
votes
1answer
68 views

Making a Request form that pulls from Calculated Columns of other list

I'm new here (first post). I have already read the great articles on this page but never posted until now. I am looking for some guidance on this and hope you experts can help me. Overview: I want ...
3
votes
3answers
6k views

Creating CASE statement with Calculated Column

I am using SharePoint 2010. I added a new Column and made it a Calculated Column. Now I need to place a CASE statement in my Formula. Something like this... CASE when [Region1] = 'A' and [Region2] ...