-
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…
-
Email Function Not Working
Hello Group-- Noob here. We created a form where once it is submitted, an email notification is supposed to be mailed to two recipients. Everything works as expected, except the recipients are not receiving their emails. Troubleshooting includes having a copy of my form entries sent to me = works. Intended recipients…
-
Dependent dropdowns using Smartsheet Sync & Google
Hello, does anyone know is it possible to create a google form and link it to an existing smartsheet rather than create a new smartsheet??
-
Link sheets so when "checked" it adds to another sheet
Hello, Is there any way that I can use a check box to then add an item to another sheet? Thanks, Harrison
-
IF Function Due Date
I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days with the due date, I would like it remain yellow until a date is entered in the completed column, then I would like it to…
-
Difference between Team and Business Licenses
Dear All, New to the community. I needed to understand the main differences between the Team License and Business License. As small background, I am working in the PMO of a transformation programme and we are introducing Smartsheet primarily for maintaining the work stream plans and the overall resource planning. We are…
