-
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…
-
Restricting access to certain rows
I have a smartsheet for travel requests within an organisation of about 2000 people. Each row contains the requester's e-mail and details about date, destination cost and purpose of travel. I then use formulae to display remaining budget, etc. to approvers. Within the organisation there are about 15 people who can approve.…
-
Date format on workspaces
I had the following questions on date formatting: 1. If I change the format in personal settings (admin account), does it impact other users and their work spaces? 2. Can I maintain different date formats for different workspaces - say workspace one following US and the workspace two following UK? If not through personal…
