-
Dynamic Views & Dashboards
Can you add a dynamic view to a dashboard for easy access?
-
COUNTIFS Unparseable
I have two formulas that are currently returning correct values, but I want to combine them and only return the count if both criteria are fulfilled: =COUNTIF({Approved Avalara Fixes - Form Required Range 1}, "Name") =COUNTIF({Approved Avalara Fixes - Form Required Range 7}, NOT(@cell = "Child")) Above are the two formulas…
-
Help With Collect Function
I have a sheet that has three columns - DueDate, Status and "Status by Color" respectively. Based on the entries in the status column the "Status by Color" cell is assigned the color Red, Green or Blue. My need is to identify the 5 oldest 'overdue' dates within the DueDate column. I achieved this using the following…
-
Update Sheet 1, Based on Submission to Sheet 2
I 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, that a user submitted something on Sheet 2. My first thought, is to use a VLOOKUP…
-
Vlookup functions not working on a Master Spreadsheet
My 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 columns on the spreadsheet in question, pulling data from a different source sheet…
-
How to include formula to perform a count from the keyword in the row and update the count?
Hi expert, Not too sure if this is supported within the function. I have a used case below, I need tester to input their test result in name assigned in the column (Col E-G). Once they input the status = "P" or "F", the Column 'Total Pass' and 'Total Fail' will do the count base on the condition keyword P or F in each row…
-
Median formula showing highest value from range.
Hi 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, I got the correct median value. But after sometime, the metric sheet gets refreshed…
-
How can I convert YYYYMMDD to a SmartSheet date value?
I have about 2500 date values, imported from an Excel spreadsheet, in the YYYYMMDD numerical format. I would like to convert them to Smartsheet date values. Any suggestions?
-
Is there an automated workflow that populates data in cells based on triggers and conditions?
Hi Smartsheet SMEs! Please share any success you've experienced in creating a workflow to automatically populate cells using select triggers and conditions without using a formula. Thanks in advance for your feedback/suggestions. Edwina -
-
The correct VLOOPUP formula?
Hello I am needing a formula that will pull an employee level and assign it to the alias listed. I have used differed variations of VLOOKUP and nothing seems to work. Breakdown: Sheet #1 will contain a list of an employee alias's, sometimes the alias will be listed multiple times. In the column "Level (Formula)" on sheet…
