-
Change cell format within a formatted column
This seems a no-brainer but maybe not: I have a column formatted as a drop-down menu, but within this column are other cells that need to be formatted in other ways, such as dates, currency, and others. Any way to do this? Thanks in advance. Dennis
-
Automatic Column Updates?
Hi I am trying to create a formula that is set for the whole column in the sheet. What I want to happen is whenever the Status of the Harvey Ball is full, the "Done" column well create a check mark in the cell. Is this possible? If so, how? Thanks.
-
Labs - Smartsheet Charts
I know Labs isnt officially supported, but I thought someone on here might know what I'm doing wrong. I have a very basic data set I am trying to graph using Charts. basiclly a date and a volume delivered: Eg: 13/01/2017 525 14/01/2017 612 15/01/2017 599 Etc. However, when ever I choose a graph option, i get this error…
-
Resource Allocation across multiple Smartsheet accounts
I'm experimenting with Smartsheet to assess suitability to manage multiple engineering projects. Question I have on resource management - if I have a number of projects within my work-space and a colleague has similar but seperate (but we do not access or collaborate on each others) and we need to share a common resource…
-
Once a field is marked to yes ignore the rest of the formula
I am trying to create a sheet where as a step is completed the steps are updated with a checkmark symbol. As a drop down comment is added in a column the formula updates the step to complete. However onece I change the drop down comment the symbol changes back to "No" or X. I would like to know if there is a why to write…
-
Highlighting multiple changes
Team, I am using the 'Highlight changes' feature, currently set to highlight any change made within the last day in bright yellow - great. However, due to our work flow it causes me a problem. When we enter an entire new row it goes bright yellow (as it should). However, then, if another user makes an amendment to one of…
-
Formula Help
So I need some help with a forumla, not sure if its possible or not. New to smart sheets as well so im hoping for some guidance. I have a Sales Pipeline document that ive created to track all projects in the sales pipline with summary info at the top of the page on how many jobs are in each stage of the process and the $…
-
Calendar Days inactive - please help
We use Smartsheet calendar to schedule in our sales - however the month of january is greyed out and inactive? Cannot add any events in - only way is going back to previous months, adding, then changing the date to january ? Any ideas how to resolve this issue?
-
Automatically including new rows in formula
Other than SUM(CHILDREN()), what's another way to include newly added rows into formulas? My scenario is this: I have a parent with multiple children, and new children are guaranteed to come in. I want to sum a column based on the condition of another column. How can I use the SUMIF to include newly added rows without…
-
Chrome crashes when copying/pasting cell text
Running Win 7, Chrome Version 55.0.2883.87 m (64-bit)
