-
Populating Entire Columns Referencing Another Sheet
Hi all! Over the last week or so I have been trying to build a report that shows average tasks completed over a given 12 week period. So far I have been successful in creating the formulas for these, which have been working on dummy data. Now I would like to process live data from another sheet. Well ideally I would…
-
Date Stamp Workflow Automation not working
I have a simple workflow automation that I created which is not working. It is a date stamp action to be recorded in a date-specific column, with the condition being a sum reached in a text/number column, and with the trigger being a row added or changed. My sum column (2022 - Total) works correctly, adding the sum of 8…
-
Average Percentage for Parent Rows
My current formula is calculating the average percentage of parent & children rows. How do I get it to look only at level 1 rows? Here is my current formula: =INDEX(COLLECT([% Complete]:[% Complete], Level:Level, 0, [% Complete]:[% Complete], <>0, [% Complete]:[% Complete], <1, [Current Phase?]:[Current Phase?], 1), 1)…
-
Formula to find the average word used in a column
Hi, Is there a formula I can use to find the average "word" used in a column? For example, I want to find the average of these words from the drop-down list: Cheers! Ann
-
Function to calculate date of next Monday
Hi all, I'm trying to add a function in a summary date field that simply notes the date of the next Monday from today. It feels like it should be simple, but I'm struggling to wrap my head around the TODAY function. Can anyone suggest a formula that might work?
-
Sum time to total Hrs for report
Am looking to total our [task time] in manufacturing. Tasks are allocated a start date and end date with the WH manager changing the duration per current Smartsheet options i.e.; 1h or 1h 30m or 5m or 1.5d. How can I total the hours for a monthly report, we work on an 8Hr day.? Have seen many threads some come close others…
-
How to turn a numerical text date into a date value
Hi all, We use a form to gather registrations for events that are constantly changing. At any given time we will provide 5-8 dates to select from and update it every month with new dates. In the form, the participants must select the date they plan to attend from a dropdown. To my knowledge, I cannot actually do this with…
-
How to count 2 columns of checkbox as 1 if both are checked and 0 if only one columns was checked?
Hi! I've been trying to get the right formula for counting 2 columns with checkboxes as 1. Basically, the 2 columns are morning and afternoon. Each column has a checkbox and will be checked if they were present. And if they are for both morning and afternoon then the next column should be 1. So if anyone knows the formula…
-
Finding unique values from Column, then listing them in another sheet
Here is my problem: I have a column that has multiple different dates listed. I want a formula that will allow me to find the unique dates and then list just the unique dates in a different column. I have done a lot of research and I know I need a helper column but I'm struggling with the examples I have found. Any…
-
Generate List of Unique Values - INDEX? DISTINCT? VLOOKUP?
I'm trying to have Smartsheet create a list of unique data *without* using Reports. Help (-: In the Names table in the screenshot, you can see that there are names manually entered a number of times in random order. That is fine and good. What I'm trying to do is is have a second sheet have a "Names - Unique" column which…