-
RYG status for it to be blank (no ball) in column
Hello I need some help with a formula. I have a status column that is linked to the "status of contract" column and depending on the status of the contract, the balls will be green, red or yellow. Issue I'm having is for it to be blank (no red ball) whenever the status of contract is blank. This is the formula I currently…
-
How to adjust numeric format when combining cells
Greetings, Community! I am attempting to concatenate three cells containing numbers and retain the decimal places and 'thousands' comma separator. I've searched high and low for an existing solution, but not finding anything. Here's a snip of what it looks like. The '121410' is coming from the sheet grid; the other figures…
-
Automated adding in project
Hello, I have a portfolio of about 80 projects, each with their own project sheet and all built on the same template. My organization has several functional groups (lab operations, procurement etc.) that work on their portion of these projects. These functional groups would like to start using smart sheets to manage their…
-
COUNT ONLY IF A CELL HAS A VALUE
Hello, I would like to get a formula to that refers to another sheet to count only if a certain column has a value. Help please!
-
Sheet Summary
I would love it if Smartsheet had a more robust sheet summary, rather than creating those using formulas on the grid, or creating a dashboard to pull in those summaries/formulas from numerous grids. The sheet summary on the right menu often doesn't capture all that you would like and give limited flexibility in capturing…
-
COUNTIFS with FIND and ISDATE
Hello, I'm trying to create a COUNTIFS formula to count cells in a separate sheet that contain 000 in their 6 digit ID number column and have a date in a different column. The formula below is giving an error: =COUNTIFS(({Dashboard Source Sheet Store #}, FIND("000", @cell) > 0), {Dashboard Source Sheet AIC Date},…
-
Index/Match formula based on date range?
Hi. I am looking at setting up a formula to reference another sheet's key accomplishments and major upcoming activities column based on a date. Right now it's set up to where we populate the original sheet by the Friday of each week. I've played around with getting the index formula to work but am struggling to build the…
-
Using SUMIFS formula to add up certain date ranges
Hello, I am in need of a formula that will add up certain date ranges. With every project that is virtually supported, our potential cost savings is $2200. Now, going off of the "Arrival Date" column, I want to add up the projects virtually supported based on quarters of the month. What SUMIFS formula would I use to…
-
JOIN/COLLECT multiple checkboxes into a text/number column
Hi all, Using Paul Newcome' solution in this post, I came up with the following working formula: =JOIN(COLLECT($[Add to ABE waitlist]$1:$[Add to Transitions waitlist]$1, [Add to ABE waitlist]@row:[Add to Transitions waitlist]@row, @cell = 1), " AND ") But I can't convert it to a column formula because of the absolute…
-
Link a column from one sheet to another sheet.
I have a detailed sheet which I input a wide range of information useful for my usecase, but I want to make a summary sheet that only shows certain columns to a 3rd party so they can just see the information that they need. I need new rows of information to automatically link to the summary sheet when new entries are made.…