-
Basic Logic in Forms - Not working
Hi all, Im setting up a form, and what should be quite simple doesnt seem to be working for a logic request. I have a question midway through the form, if the user selects the anser 'Yes' from the dropdown (field A), a field appears to answer (Field B). If its a no, then the field stays hidden and move on to the next…
-
IF OR formula for 3 conditions
Team, Struggling to get the below formula to work…any thoughts. (The cells contain numbers in text/numbers columns): =IF(OR([02/01/25]@row < [01/01/25]@row , [02/01/25]@row <> [01/01/25]@row , [02/01/25]@row > [01/01/25]@row ), "Down", "Same", "Up") Thanks
-
Formula for Multiple same names count once AND single name counted as well
I used this formula from another community post which counts a person's name only once if it appears multiple times in the column. However, it does not count a person's name at all if the name only appears one time and I need it to. In the example below, how can I get it to count Doe, John as one AND Mouse, Mickey as one…
-
Inventory Grid
Hello, I have built a sheet to track stock/item quantities. I am wanting to show a live count of stock levels. I have used two separate columns for the item quantity so the people handling the stock can use a mobile device form to enter the data. I have also created a report to show the in and out sum of each item, but i…
-
Formula Issue: Sum of column based on data in two other columns argument error
Hello, I am running into an "incorrect argument" result. I have a sheet and am using data from another sheet to pull information and add it together. I am trying to reference three columns in the first sheet: column one is total cost, two is fiscal quarter (Q1, Q2, Q3, Q4) and three is last name. My goal is to total in the…
-
Formula for Tracking
Hi everyone, I'm struggling with creating a formula to track the progress for my project. So I have created status for each activitie which need to be done. However, I don't know how to link them and turn into % of completed progress. I will attach the image below. For example: When Venue Booking is Done. The % of…
-
Troubleshoot Workflows/notification not going to specific people (index/match formula driven)
Hello! I have a universal intake sheet to manage a variety of request. Assigned approvers are populated based on index/match formulas using a contact column. The notifications are working for everyone except one person. Oddly enough, when I push the notification as a test (and notify me), I don't get the notification…
-
Smartsheet Calendar unable to update health status on source sheet
Hi, I created a Smartsheet calendar organized by Phase and then Workstream, with deliverable bars spanning duration. The goal is to create an interactive Gantt chart, which team members can update tasks on the calendar detailed side panel. The formula on the source sheet states that if At Risk is checked then Health is…
-
Countifs calculation get wrong number
Hi, I use a metrics table to calculate how many items in CNPA summary table. I want to calculate how many "Basic information" in Request Items column in CNPA summary table. The formula I used in metric table is COUNTIFS({Request Items},"Basic Information(location, die size…)") It returns 80. However, there are only 71. How…
-
Metrics Pulling Help
Hi there! I have a submission sheet and a metrics sheet. I am attempting to create a formula on the metrics sheet pulling from the submission sheet. I have no trouble pulling counts, but averages are giving me some trouble.. I am able to pull the average based on 1 criteria, but no more than that. I am looking to average…