Cell linking
Discussion List
-
Having Issue with "COUNTIF" returns "0"In Formulas and FunctionsHi Guys, I have to count the status. Let's assume I have 5 different statuses (0,1,2,3,4) in another sheet. I have prepared a separate metric sheet to count the status specifically for a date range but I got the result as "0" for…Answered - Pending Review 21 views 3 comments 0 points Most recent by Malaina Hudson Formulas and Functions
-
Trouble using countifs referencing another sheet and adding either "NOT" or an "OR"In Formulas and FunctionsI am trying to write something that will do multiple countifs and either include a range of ORs or allow me to exclude rows that have a particular response in a given column. =COUNTIFS({NEOP Tracking Range 2}, [Column5]12, {NEOP Tracking …Answered - Pending Review 10 views 2 comments 0 points Most recent by Patrick Vermaas Formulas and Functions
-
Webhooks vs Built-In AutomationIn API & DevelopersI know that automated workflows in smartsheet won't take place if the trigger is a change on a cell link. Will the same happen in the case of when a webhook is triggered? Will a webhook send if the trigger is a cell linked column?
-
Can I use formulas to pull in hyperlinks from other sheets?In Formulas and FunctionsI want to use a formula to pull in hyper-links across formulas. I started with: =IFERROR(INDEX({Client Intake - Client Invoice Log}, MATCH([Client Name]@row, {Client Intake - Client Name}, 0)), "") but this only pulls in the tex…
-
Help with Trend DataIn Formulas and FunctionsI need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is calculated from the project Status. …
-
Update Sheet 1, Based on Submission to Sheet 2In Formulas and FunctionsI have a quick question. I have 2 sheets (Sheet 1 and Sheet 2). In Sheet 2, users submit a form and a field (which is hidden) is automatically checked indicating it's been submitted. What I'm wanting to do is - essentially - notify Sheet 1…Answered - Pending Review 15 views 4 comments 0 points Most recent by Mike Rini Formulas and Functions
-
Vlookup functions not working on a Master SpreadsheetIn Using SmartsheetMy colleague and I, who do extensive work on a master spreadsheet that pulls data from many different sheets, are having a lot of trouble with the vlookup function on this particular sheet. We use the vlookup function in multiple different…
-
Median formula showing highest value from range.In Formulas and FunctionsHi everyone, I have two sheets, a master sheet with cost data and a metric sheet with formulas to get a summary. In metric sheet, I need median value of certain items. I have used MEDIAN & COLLECT. Problem: When I updated the formula,…
-
Self-updating report based on sheets in folderIn Formulas and FunctionsHi there, Is there a way that I can build a report so that when a new sheet is added to a smartsheet folder, the contents of the sheet then automatically gets compiled into a report? I saw that it was possible to select a folder when bui…
-
How do I set up a workflow to notify someone if a predecessor task has been completed?In Using SmartsheetI am currently trying to develop a project plan sheet, and I am wanting to be able to notify someone when the predecessor task was completed so they know they can start working. For example if John has to do a Data Source Identification a…