-
How to use MONTH(sheetrefencerange) in a SUMIFS function?
I cannot get the function below to calculate correctly. I keep getting 0 for the sum. =SUMIFS({Hours}, {Input Date}, MONTH({Input Date}) = 4, {Project ID}, [Column2]@row) {Input Date} is a column reference range in another Smartsheet. {Input Date} is an auto-generated date/time column.
-
"You have too many activity log events to display at one time" - why?
EDIT: on refresh, this error message actually disappeared and I can now view the Activity Log in it's entirety without adding a date range filter. This is also happening on another few old sheets - error message appears but if I refresh the sheet it disappears. Maybe something is broken! Has anyone else experienced this…
-
Formula Help: Combining Checking a Box with a % Complete to Return a Status Ball
I'm having a hard time combining a formula that when I check off the "Done" checkbox it turns the % Complete to %100 and also changes the health to green as well as combining the criteria of this formula: =IF([% Complete]12 < 0.5, "Red", IF([% Complete]12 < 1, "Yellow", "Green")) Is this possible?
-
Best formula to return a list of qualifications for card view
Hi Community, So, I am trying to save myself a lot of manual data entry. Ultimately, I am trying to take a spreadsheet that was created in Excel, to capture each persons "qualifications" in a specific field, and get it into card view. I have attached the files of what I am starting with and what I would like to end up…
-
Smartsheet Form will not accept responses from all users
I created a Smartsheet Form and have begun receiving responses. One user indicated his response would not submit (See attachment). I verified his responses were not recorded on the Smartsheet. He indicated he was using Google Chrome to submit. I opened the Form on Chrome on my web browser and was able to submit his…
-
Date not recognized in column
I have data coming into Smartsheet from a Microsoft Form, and I'm not sure how to get smartsheet to recognize the data as a date. I tried to create an additional Date column, and putting in a formula to copy the date from the original column (hoping that the settings of the new date column would make the data officially a…
-
Surfacing Text from one sheet to another
Is there a way to surface text from one sheet to another if a checkbox is checked on the source sheet? I have a sheet with a list of meeting participants and checkbox columns for each of the meetings associated with the program. Some people are in all of the meetings, and some are only in 1 or 2. I'd like to know if there…
-
Assistance Needed with Formula to Identify Late Tasks
I have a Helper Column that I've created in order to tally Late Tasks based on entries in other fields. I want the Late Task column to be populated with 1 if the following conditions are met: [Open Task]# = 1 and [Due Date]# is less than Today. I tried the following formula and receive #INVALID OPERATION when the Open Task…
-
Join columns, not side by side, and skip columns with no info
I am looking to join multiple columns using a "-" as deliminator and I dont have the columns side by side to select range and use Join function. I also want it to skip columns that are blank. Also - I notice in Smartsheet i have to use date format 10/15/2020 is there a way to change it to 10-15-20 (I use "-" as separator…
-
Formula or Rules to AutoPopulate Columns in Sheet
I have a master data sheet where a team of 30+ people will be adding 2021 data and creating our annual plan. To make it easier for them to complete the sheet, I wanted to have the ability to autopopulate certain columns based on their answer from a drop down choice in an earlier column. As an example: 1) If they select…