-
Exporting History Data
I would like to export history data from an existing project, and tabulate the history data in excel. For example, I would like to see how finish dates have changed over time, for hundreds of rows, over the course of a project that has already finished. Is there a functionality to export a cell's (or selection of cells, or…
-
RYG symbols and nest IF's
I'm new to the community and frankly new to Smartsheets... I'm building some RYG indictors to give a quick visual indicator when a task is at "risk".. my nest IF statement is set to track a task against TODAY() - Finish... ie the closer the Finish date comes to Today's date, the higher the risk. My challenge is the Green…
-
Programatically select a subset of a column
I want to be able to average, or other function, over a subset of the cells in a row. The number of cells I want to include is specifiied in a separate cell. In Excel, I accomplished this with OFFSET. I read another article here noting that smartsheet doesn't have OFFSET, but that MATCH and INDEX might be able to be used…
-
Notification within smartsheet is not working
Hello, I don't receive any notification when other users made a changes! any ideas?
-
Index and Match - Referencing a different sheet
Is it possible to do an Index and Match referencing another sheet? My formula works when I am using data on the same sheet but when I try to reference a different sheet it does not work.
-
Cell Linking/Formulas in Reports
Has anyone worked on implementing cell linking from reports to worksheets and customizing reports? I dont see much in having reports if you cannot customize certain things after running, such as: formulas for totals in reports, conditional highlighting in reports, adding custom columns in reports. Also, without a cell…
-
COUNTIFS criteria is CELL+anything
Hi, I've created a rather complicated cross-sheet formula that counts cells from a different sheet using 3 criterias. One is the description that starts with a text mentioned in a cell above. I've tried to enter the search criteria into the formula like this =COUNTIFS({Other sheet Range 1},$Column$14 & * , ...)…
-
modifying formulated cell in a report
In our main sheet, we have several simple Sum formulas for numbers and some for dates. We have several reports created that contain columns with the formulas. While in reports, you can change some data in each cell that will carry back to the main sheet and save. Other data is not allowed to change (even if the column is…
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
Named ranges in a formula not "actively" importing from cells expire.
I folks. I think I found an edge-case in your new cross-sheet formula system. I wrote some index formulae to pull related data from other sheets when the user chose some options from a list. All was working, and I was able to link, customize and test the named ranges. I got my two sheets converted to the new system and was…