Circular Reference with formula

i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back.

I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped"

I have tried adding in another layer to see if it would help, and every time I try something else, I keep getting the same error.

Find more posts tagged with

Accepted answers

florian.zbinden7

hi,

is this what you are looking for ?

{08061572-6029-4F1C-BE8A-BBCDDC0C3E55}.png

if not, please provide more details and screenshots.

thanks.

Florian

All comments

Jgorsich

=if([Tracking#]@row<>"","Shipped","")

Trying putting that in your Deployment Phase column and making it a column formula.

florian.zbinden7

hi,

is this what you are looking for ?

if not, please provide more details and screenshots.

thanks.

Florian

Kimberly Poletes

this worked! thank you!!!!!!!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.