-
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…
-
Deleting one outgoing cross-sheet reference ended in ALL references from the same sheet being delete
Hello, I spoke to Support on the phone yesterday but we haven't had a definitive answer on what the expected behaviour for this scenario is. I'm curious to see what other users have experienced. In the the "Edit or Remove links" > "Outbound links" section of the Cell Links: Consolidate or Maintain Consistency of Data…
-
Adding some tricky pieces to an INDEX COLLECT formula
Anybody want to take a stab at this? I'm helping a design team estimate their effort based on the details of the work coming in. The formula will be an INDEX COLLECT with some nested IF statements. Note that this is currently on a test sheet and in the end the formula will live on an overall tactic sheet with cross-sheet…
-
Formula to change certains Dates
Hi I am hoping someone could please help me. I have attached a screen shot of three columns that will be used. What I need is a formulas that when the date paid is entered then the company review date will change by a full year and the when the company review date changes I want the due date to change by 2mths Thanks in…
-
Help with Formula for Unique IDs
Hello, I'm working on dashboard that will track a list of vendors. Some vendors have multiple locations, so the vendor name would appear the same from row to row with other fields unique to location, while other vendors only appear once because they only have one location. Those who have multiple locations only need to…