{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747915392676,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:message...
And try to create aCalculatedcolumnRevision Date (dd mmm yyyy). It because I want to change a look of date and set to (dd mmm yyyy). So, after added a formula=TEXT(Revision Date,"dd-mmm-yyyy"),I have an Error"The formula contains a syntax error or is not su...
Hi. I am currently following a development course on Udemy and I ran into this very weird error. A certain formula field is missing, it calculates a
Error: Syntax error. Missing ')'Mark as helpfulVINAY KUMAR K (Salesforce)Dec 1, 2023, 5:29 AM You can try below validation. AND(OR(NOT(ISPICKVAL(Type , "Extension")),NOT(ISPICKVAL(Type , "upgrade")),NOT(ISPICKVAL(Type , "downgrade")),NOT(ISPICKVAL(Type , "expanded renewal")...
The column Monitorar is a date/time field, but the calculated column is a number field and should accept either 0 or 1. I wasn't sure that a date could equal 0, but I tested this and it works fine: =IF([Due Date]=0,0,1) ...
I just started using a MacBook for Excel. From my previous work with a Microsoft computer, I know that if you start typing in a formula, you get the components of it shown. This does not work for my Mac. I have a picture attached. I am talking about the yellow highlighted par...
I keep returning too many arguments error - I've tried my best to adjust commas/parenthesis in a logical way to alleviate, but cannot figure it out! If I remove the final portion of the formula, it returns the correct information and reads the formula correctly: ...
{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747911723828,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject...
Your post is rather short on information, so I'm going to make a number of assumptions: I will assume that the "tables" that you mention are ranges, notExcel tables. The two are referenced using different syntaxes. You do not mention whether the two ranges ("tables") are on the same...
I would to use a formula to create a flag for a column by determining if the cell format is Currency or Percentage. For this example, IF the cell format is Currency, return Y ELSE N. 1. I will use ... =LET(format,MAP(amount,LAMBDA(a,CELL("format",a))),IF(LEFT(f...