-
COUNTIFS Formula
Good day, I am trying to write a formula that combines 2 sections for a dashboard. I want to do Assigned to + % Completed. If I do a countif formula that references assigned to only, data populates accurately. But if I do the below formula, I get #INCORRECT ARGUMENT SET. Whats weird is that this exact same formula on a…
-
Can the Duration column type be converted to a column formula?
I would like to use the duration column type, but it's not letting me convert to a column formula. Is this possible? Formula:
-
Issue when values from form are not added into the sheet
I am trying to create a form that records the number of people that walk into a store, if they purchase a product then we will add it as revenue. When I am trying to complete the form for the employees, the formula that I have for sum the values it's not working for those that are added.
-
Billing Dashboard Help - Rows of Data shown on the Dashboard
I am trying to create a dashboard for our billing process at a glance. I wanted to display the rows that are checked for updates each month on the dashboard, but I can't figure out how to pull all of it and make sure it updates every month. I saw someone using =INDEX(COLLECT, but I don't know how that would translate to…
-
INDEX MATCH MATCH where the cell is not blank
Hello, I have a unique situation where I cannot do a standard INDEX MATCH MATCH. We have a spreadsheet like the simplified version attached. I'm trying to grab the data where the name matches on the left and the date matches on the top. However, since there are multiples of the same name on the left, I only want to grab…
-
Distinct Values across 2 sheets
Hello, I have 2 separate sheets, and am trying to calculate the distinct values across the 2, knowing that there may be duplicates between them. In my example, I have a project list that is pre-smartsheet, and another list that is post-smartsheet (we do not need or want to combine). How can I calculate distinct client…
-
Creating a Quiz that will score automatically
I have created a quiz but can't seem to get the sum for all of the correct answers in a particular row. Here are the formulas I am using and the results I receive once the form has been submitted.
-
Using Countifs in a cross reference formula
Hello - This is the formula I am using: =COUNTIFS({Company RAID Log Range 1}, "XXXXXX", {Company RAID Log Range 2}, "CVI") Company RAID Log Range 1 = LEAD Column Company RAID Log Range 2 = Ownership Column where XXXXXX is a person's name. This is what I hope is returned: count of times this persons name is list in the LEAD…
-
Can % Complete return a "COMPLETE" Value in Status
I am working with a construction schedule and the Project Manager manually enters the % Complete. I created another column called status and what I would like to do is when the PM marks 100%, the status column automatically reads Complete. And if they mark anything under 100%, the status column reads Incomplete. Is there a…
-
Formula for new column to get a hierarchy view in report
Morning, I am working on code to get some type of hyerarchy view in a report I added the below code and it is just coming up as blank I spread the code out a bit so you could see what I was trying to do, where did i go wrong? =IF(CONTAINS(0, [Task Level]@row), [Task Name]@row, IF(CONTAINS(1, [Task Level]@row), "--" + [Task…
