-
IF formula to validate if cell is number and is not blank
Hey Smart-Heads, I would like to create a validation formula for a cell with manual inputs. ASIN Position on SAD - column which initially is blank, later updated manually by the user ASIN Position on SAD - Number Check - column which checks the inputs provided. Values and scenarios: YES = 1) ASIN Position on SAD is not…
-
Convert To Column Formula
The logic appears to be correct, however, I am getting syntax error when trying to convert to a column formula.
-
Is there a way to add/remove radio button options based on the logic of a previous answer?
I’m putting together an employee shirt order form. I’d like to make it so they select the shirt first. Next question is size, and the next is color. However, not all sizes and colors are available for all shirts. Using logic, would the radio buttons for size and color adjust based on the shirt they select?
-
Search for Text in a Referenced Sheet
Hi, I am trying to search for text in another sheet column that I am referencing. Error comes back as Incorrect Argument. Everything before the CONAINS function seems to work fine. I can't get the CONTAINS to work with a sheet reference. =SUMIFS({2023-24 Estimated}, {Fund 41}, "05 Cap", {WBS}, "Facility Upgrades…
-
Cross Referencing and sum formula
Hi all, I am working on this new sheet, and have successful formulas from previous sheets that work great. However, I have hit a roadblock here on this one. This formula looks at the Errors sheet I have, and a column that produces a 1 if there is data in the column next to it. With that, I have a consolidation sheet that…
-
How can I create an INDEX and MATCH with 4 conditions?
I am creating a Tracking Sheet where the vendors are assigned to specific team members. In the Tracking Sheet (Sheet #1), there are 2 columns to look at: Coverage Method and Service Provider. If the Coverage Method meets any of 4 criteria, then it should look at the Vendor Sheet (Sheet #2) and return the correct team…
-
Need to have a dashboard show only Current Month status but different column for each month
Hello! To explain: We have a goal-setting Smartsheet template. In the template, there is column for each month (the row is the goal) So, for row #1 (the first goal), there will be a column Q1J (Jan), Q1F (Feb), Q1M (Mar), Q2A (April) and so on. The end users I want to only fill out the column for the month we are in, and…
-
Help with Parent Check Box and Children Aligning
Hello, I am trying to get he children to automatically be checked when the parent is checked off. I was trying to get a helper column to assist, but something is just not clicking in my head to make this work!
-
Duration column chart for a dashboard
Hey, I am trying to build a chart that shows me the duration of the tasks. I would like this to be a bar chart, so i can see how long each task took in comparison (these are the same tasks in different projects that take people different amount of time). I am unable to use a report that shows the primary column and the…
-
Formula COUNTIFS, criteria in multiple columns and MTD
I have a sheet that lists every call for service that shows the Date, Crew1, Crew2, if it was a transport, and if it wasn't, the reason for not transporting. I'm trying to get a formula to work that counts the total calls that a crew member ran in the current month and how many of those calls did they transport. I can't…