-
Looking for Formula Help
In my sheet, I have two columns. One entitled "Hotel Check-In Date" and the other "Hotel Check-Out Date". So someone might input: Check-in 11/20/19 and out on 11/25/19. I know have individual columns for each date: i.e. 11/20, 11/21, 11/22, 11/23, etc. I am looking for a formula that will be a value of "1" in the correct…
-
Formula Error - Sumifs
Hello, I'm trying to build out a SUMIFS formula that adds up timesheet data from a separate data sheet using 4 criteria: employee name, project code, start date and end date. The formula works fine if I don't have criteria for project code. As soon as I add another criteria to match the client code, I get an #INCORRECT…
-
Remove Symbols
OK, so, we have an update form that goes out to about 30 people. All they have to do is add the latest figures and click 'Send'. That's it. However, they insist on adding in symbols and text, no matter how strenuously we explain that they shouldn't. All they need to do is enter 55 not £55.00 or 0 not N/A. But they persist.…
-
Zapier and Formulas
I'm trying to use Zapier to input formulas into a Text/Number column (which does support formulas) and it comes over as a text string: '=INDEX(PARENT(), 1) I'm using Control Center which creates new rows on a sheet via cell links, but the auto-fill function doesn't seem to work when the new rows are added here; hence…
-
Help with date formula/automation
I am trying to help a user automate a current process in Smartsheet. The information within the sheet is compliance info and each item has different regulatory rules. Some items have monthly update requirements, while others have quarterly or annual update requirements. Right now the sheet admin goes in the sheet to see…
-
Return top 5 occurrances
I have a sheet to track customer requests (500+ rows), with a Salesperson column and customer column, the salesperson column is located farthest to the right of the sheet whereas the customer column is located on the 1st column. What I want to do is write a function that will reference a given Salesperson contact and be…
-
Summarise Tasks into single cell
Hi there Smartsheet Community! I have been a smartsheet user for a few years now but this is my first post with the community (so i'll try my very best to describe my issue) I use two different sheets for planning in my company, which is currently manually updated. I am hoping to link these sheets together so that…
-
Function Help - Sheet References
Hi there - I am working on building a slightly better project tracker for our organization. We currently utilize calculated fields that we have to define for each new project, and sometimes the project does not have enough project rows to account for all items we are tracking. I need help with a specific formula that would…
-
Return 1 if YEAR and MONTH is equal TODAY
Hi, I have a formula: =IFERROR(IF(MONTH([Sale Date]2) = MONTH(TODAY()), 1, IF(MONTH([Sale Date]2) = MONTH(TODAY()) - 1, 2)), " ") and it worked until we have two years in one sheet. I would like to know how to add YEAR to this formula so that we can compare not only MONTH but also YEAR. Thanks.
-
Formula in parent row for updates in child rows
Hello! I have my sheet set up so that all of the update columns in the child rows are automatically a red dot. Once a row has been updated the cell turns to a green dot. It will stay green for 4 days as I have the formula set up so that on Mondays I can see if any PM's have updated the sheet since Thursday (4 days…
