Cell linking
Discussion List
-
SumIF HAS with cell linkingIn Formulas and FunctionsHi All, I have been struggling to find a solution on how to get a Sumif formula to work. Essentially, I want to Sum if a cell contains a specific name, however the name column is multiselect and can have multiple people in it. I have trie…
-
Why sometimes a formula works and other times it shows #CIRCULAR REFERENCE?In Formulas and FunctionsI am working with this formula IF(ISBLANK([MoH ID]@row) = true, "", IFERROR(VLOOKUP([Val ID MoH]@row, {2.1 MoH Range 1}, 16, 0), "Error ID Trámite")). It worked for a few weeks and then suddenly when I open the sheet th…
-
Is there a way to have a date change in autofill within a formula?In Formulas and FunctionsI am looking to shift the way my data is displayed so I can place it in a dashboard. To do this, I'd like to shift the information within to do a specific date and return that. My formula works fine, but I have to change the date for eve…
-
Cross Reference Countif Formula is giving Unparsable Error.In Formulas and FunctionsI am hoping someone can help with Countifs formula referencing another sheet. The current formula that I have works great on the master sheet. =COUNTIFS([Resolved Date]:[Resolved Date], >=DATE(2021, 3, 1), [Resolved Date]:[Resolved Date…
-
Can I turn off the "Used in formula on" information screen?In Formulas and FunctionsI have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?
-
auto populate data from one sheet to anotherIn Using SmartsheetHello everyone, I'm new to Smartsheet but do have a fairly robust knowledge of Excel. I've created a sheet with job codes, associated titles, and pay rates. A row has a venue name, a job title, a department, and a pay rate. I would like t…
-
Pulling Data from Second SheetIn Formulas and FunctionsTwo Sheets: I have one sheet labeled "Permits" and one sheets labeled "Project Tracker", Each sheet has a Column Labeled "Job #" and "Permit #". What I'm looking for is if Job # match on both Sheets…
-
Wrong date format on hyperlinksIn Using SmartsheetHello all, I have searched this topic but can't find anything. I'm using UK date formats in my companies sheets and our account is set-up in UK format, however when I link a date from the source sheet into the new sheet the date is displ…
-
Converting Cell Text to HyperlinkIn API & DevelopersHi. I have a formula in a cell that generates the name of a course using text from other cells (e.g., BUS-430-BL-6W-1D-Master). FORMULA: =LEFT([Subject + Course]2, FIND(" ", [Subject + Course]2) - 1) + "-" + RIGHT([Su…
-
COUNTIFS between dates & criteria.In Formulas and FunctionsGreetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: …
