-
Custom colours in grids
Hello. I love that custom colours can be selected by choosing the hex code or RGB values. This is especially great for the dashboard views with the graphs, titles, etc. One problem though is that we do not have the same option in grids. There the standard colours are the only options. Is it possible to add this to grids,…
-
Why won't my COUNTIF formula not count anything from source sheet?
Hi all, I currently have a system for three spreadsheets: 1) Masterlist for open/closed actions that feeds a 2) Open Actions sheet, and a 3) Closed Actions sheet. The formulas for the first two sheets work perfectly, however, when it comes to the third sheet (Closed Actions), my COUNTIFS formula will not count anything on…
-
Auto- Number based on Parent child relationship
I want to auot number based on the parent . i.e if I have a number items (Parents) I want these to be auto numbered but any item below them, indented to be for example 1.1, 1.2, 1.3 etc. on the first parent level of indent and the next similar 2.1, 2.2, etc. Any idea to automate this?
-
Summarizing items by country
Hi there - I am working on a dashboard and would like to summarize content created in a region and then by country. Right now I have this set up manually with a formula based a static list of countries, but I am hoping there is something I could do that would pull the country list automatically from the column, as new…
-
Smartsheet Slow or Not Loading
Is anyone else having issues with smartsheets not loading over the past couple of days? Everyone at our company has been having issues with smartsheets failing to load since Monday 21/06/21. Some small basics sheets do load eventually, however larger sheets with a lot of rows dont load at all. prior to monday, these same…
-
Highlight Changes
Hello, I want to know when information has been updated in a sheet, how do I set this up so any changes made in the last X days highlight the cells? Thanks, Hannah
-
One off Saturdays in Gantt
Hi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of opening Saturdays for the duration of project?
-
Enhancement Request: Ability to lock a row if if a task is dependent upon another being completed
Example: There are Task 1 and 2 and Task 2 has Task 1 as Predecessor task. Until Task 1 is marked completed, Task 2 or some of its columns are LOCKED and cannot be edited.
-
Form required fields - preventing form submission?
Hello! I'm wondering if anyone knows of a way to prevent a form from being submitted with empty required fields. Let me know what you know! I'm hoping there is a way to do this. Otherwise, this doesn't feel like they are truly required. Just strongly suggested. :) Thank you so much in advance for any guidance or knowledge…
-
Continuously evolving Sum formula
Is it possible to create a formula or workflow that would move/update our "90 Day total" column as new months come and go? I've attached what we are currently working with. The 90 Day Total is just a sum formula for each Jun Jul and Aug. The rest of the year is mapped in the exact same style, but for Sep Oct Nov and Dec.…