Formulas
Discussion List
- Hello Gang, I've been losing my sleep over this formula so I thought of asking here. I need to determine whether a certain value is found in another sheet and if the date of that value if found within…
- Hello, I am having trouble using an IF statement across multiple sheets. Basically, IF a row has a specific word, it should pull the column I need. Or was there never a link like this before? Thank yo…
- Hello, I am trying to pull distinct information from a different sheet if a box is checked. Here is my formula to pull in the distinct information: =IFERROR(INDEX(DISTINCT({Source Sheet Column_Name}),…
- Hello, I have an index match formula but when I drag it down, the row number doesn't get updated and just drags the same formula down. Is there a way to drag this down and have the formula update rows…
- I am trying to flag a line where the Actual Finish date is blank or the Actual Finish date is past the Estimated Finish date. How would I set that formula up?
- Hi there - I have created a form with 4 questions that has dropdown (multi select). In the smartsheet itself, I need formulas for the following: If all boxes are checked then show 0 If only 2 of the 4…
- Hey Guys, I've been trying to find a solution but I'm stuck. I have a 'master' sheet that has a multi-choice column for countries of operations for some partners. The choices will increase over time a…
- I created the sheet and set up the automation as below. however, it doenst trigger to send the notification for the current week unless I open the smartsheet. it still send out last time I open the sm…
- I have a Disbursement tracker, showing Request Status, Date Requested, Amount and Project. I have another sheet, Project Plan showing the summation of Disbursements by Project. I am currently using th…
- Hello, I am trying to find out how I can create formulas for the below. Kickoff Date - Number of rows with a kickoff date by month? IE Count of projects in a column with a kickoff date in Jan, Feb, Ma…