-
Did changing the column title permanently break the formula from sheet to sheet?
I have a dashboard where I use a calculations sheet in between the dashboard and the sub sheets. For each, the formula is =COUNTIF({Type of Resource}, "Council Publication") with the item in quotes changing for each resource being tracked on different lines. The outcome continues to say zero, when there are counts to…
-
Using symbols for assigned to
is there a formula that automatically displays the person icon based off of the number of resources in the assigned to column vs using the drop down?
-
Delete a row
Hi Are there any methods to delete a row after meeting specific Conditions ?
-
can I create a form from a sheet and apply it to all my existing projects in my blueprint?
-
Current Week vacation formula
What did I mess up in my formula to calculate from another sheet, the number of drivers taking vacation in the current week for my dashboard? =COUNTIFS({Vacation Intake Sheet Range 1}, "<=" & (TODAY() - WEEKDAY(TODAY(), 1) + 7), {Vacation Intake Sheet Range 4}, ">=" & (TODAY() - WEEKDAY(TODAY(), 1) + 1)) For context, the…
-
Block the report being sent if it contains no data
When sending a scheduled report as an excel sheet, we have some teams who are receiving blank spread sheets. Is there a way to block the report being sent if it contains no data or put a message that there's no action or data?
-
First day of week configurable in every representation
Hi, for those in countries where the first weekday is NOT SUNDAY, being able to configure the first day of the week for all settings (including calendar picks etc.) to be another day would be very 21 century ;-) So come on Smartsheet, start a new initiative to recognise the whole world ;-)
-
Automation in Control Center Global Updates
Hello Smartsheet Developer, I have a sheet with an automation that copies rows to an archive sheet, which is part of the project blueprint assets. However, after provisioning a project, the automation copies rows to the base template instead of the provisioned archive sheet. This requires manually updating the automation…
-
Help with Unparseable Formula: Understanding NETWORKDAYS and Column Reference in Smartsheet
This discussion was created from comments split from: Planned % Complete.
-
Resizing of the Gantt Bars
When exporting our Gantt's to PDFs, we often like to increase the font size of our task name and dates to make it easier to read. This typically makes the row height taller, however, the Gantt bars do not increase height along with the row height. They remain small so visually it is very hard to read in PDF. It would be…
