-
How do I populate dates from a date column into my date formula?
I'm running a Countif function that counts production between two dates, currently my formula looks something like this: =COUNTIFS({Reference Column}, <=DATE(2024, 1, 5), {Reference Column}, >=DATE(2024, 1, 1)). For the date part of my formula, is there any way to input dates from two date columns so that I don't manually…
-
Conditional Formatting - Dates in the past
Hi, I want to add a conditional format on a column holding dates that will highlight those dates which are over three years ago. I thought I would be able to pick "is not in the last (days)" and enter 1095, however it only shows "is in the last (days)" For now I have had to add two conditions: "is in the past" AND "is less…
-
Merged: Sheet Summary Field - Add Format Painter Tool
This discussion has been merged.
-
Filter by Cell Color in Reports
When creating a report from multiple smartsheets, I want the functionality to be able to filter rows by color. This way, if I need the sum of certain rows/parent rows, while excluding others, I can easily do so without duplicating numbers.
-
Hover function in Forms
When creating a form, it would be very useful to add details that would show when you hover over the field. It could be similar to the details section on a column where you can see the column details by hovering over the (i). One example of this use would be to provide definitions for the items in a drop down list. This…
-
Is there a way to keep formatting from a word file (bullets/symbols) when pasting into description?
We're trying to build forms that have a guideline in the description. These guidelines are already built in word and when we paste them into the Form description the indent and symbols aren't following. Is there a way to make this format correctly? Or Is there a way to include an image in the Description section of the…
-
Header Formatting for Formulas
How do you convert the first row to mirror the header row? The Smartsheet template that we are utilizing requires us to use the first row in all formulas to pull information appropriately. When we type in the header name, we receive error messages as if the sheet cannot find the information. We are thinking that there is a…
-
Formatting Fix
There currently isn't a way to keep the format from other apps in Smartsheet. As a workaround, I paste data as plain text, using Ctrl+Shift+V or right clicking and choosing "Paste as plain text". It would be really nice if we were allowed to paste directly and keep the format from other apps such as Word Doc, Excel, or…
-
Change Background Color for Multiselect Columns in Metric Widget
Hi there! I'm pretty new to Smartsheet, so wondering about an (apparently) missing feature. I'm aware that in Sheets, multiselect columns options appear in a grey background. The challenge I'm experiencing is that when pulling those values into a dashboard via a Metric Widget, those values appear with a blue-ish/cyan…
-
Merged: Table format in forms
This discussion has been merged.
