-
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…
-
Counting the number of Red Symbols in Parent Rows Only
I would like to count the number of REDs for Parent cells only (not children). Any help would be much appreciated.
-
Building A Sheet That is Agile Velocity Focused
It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary. https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing So this creates a gant shart that shows them waterfalling off one another (but only shows where they end and not begin) It also…
-
Centering Title of Widget
Hello, Does any know how I can center a title located in a sights widget?
-
Help with nested IF statement using AND
Hello Community, I have created the below formula that SEEMS to be working but is not showing up with the color coding that typically happens when you have all your formula ducks in a row. It is returning a result, not an error, but I’m concerned there is still something missing since the text is showing up all black. See…