-
SUMIFS with date: count within the last 7 days
I'm looking to count the number of punches at various rec centers within the last 7 days. Rec centers have dropdowns with locations. Punches is a numeric value with a daily total. Each center has a daily total. I have a separate sheet for calculations. I'm looking for a formula related to each center to count the number of…
-
VLOOKUP Help
I'm trying to write a formula in my driver sheet that will search for an employee ID number in the completion sheet and return the text from a column within the completion sheet. I wrote the following but it returns a #NOMATCH value if the employee ID is not listed in the completion sheet. I'd also like for it to return a…
-
Portfolio Management - airtable vs smartsheet
I have been asked to look at Airtable. Currently our team uses smartsheet. Our team is leaning towards Airtable due to its easy and customized views, plus ability for executives and stakeholder to create their customized views. How good is airtable compared to smartsheet How good is airtable for work collaboration - so…
-
Can you use 2 joins in the same formula
IF Type = Project join Type+ID+"-"+PMO Project Name If Type = Request join Type+ID+"-"+Request Name I've tried this a couple of ways - if I select Request - it comes up as Request1000-RequestName If I select Request then it blanks out. instead of Project1000-ProjectName Formula =IF(Type@row = "Rqst", JOIN(Type@row + [Rqst…
-
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…
