Best Of
Calendar App - colour & order consistency
I have a calendar in the calendar app with 2 column groups and multiple tiles. When i set and use filters the order of the columns flips randomly (the view does not remain constant). e.g. column 1 will show group A, Group B, Group C, but if i change the filter it will show C, B, A, or B, A, C (seemingly very random) - even using the grouping order in all the combinations i can't just make it alphabetised.
The colour blocks also change as you filter or scroll through months - my team want TV = Green, Movie =Blue , Other Pink but the colours flip for now reason.
How can i make this consistent?
CatherinePaine
Permit formulas in columns with the "Restrict" value toggle enabled
I have columns that are set to take certain types of data, and they contain formulas that fill the cells with values permissible within that data type. For instance, there's a field where a formula fills in one of several options based on a cell reference, or the user can manually select one of the options from a dropdown menu. I have another field where cells reference another to return dates, but a user can overwrite that date with a different one if necessary.
If i turn on the toggle to Restrict values to the field type, I get error messages that there are values in the cells that aren't permitted: formulas in cells, even when they return the appropriate data type, are not considered a value match for the column and are removed. This is prevents the use of data validation and value restricting in fields that contain formulas, and introduces data hygiene issues that should be resolved
I would like for this to be fixed. Excel and other spreadsheet software are able to recognize formula results as a value type, but Smartsheet blocks formulas from working in fiels with value-type restrictions.
ritzbitz00
Re: Increase cell character count
There currently is no way to increase the limit, but I have run into a few instances where it would have been really nice to be able to have more than 4,000 characters. I'm adding my vote.
Paul Newcome
Re: Join/Collect , Index/Collect Multi-Select Column with Contact List return value
Hi @Jess D
That formula should work without an issue!
Here is a screen capture of how it should show up:
HOWEVER! Since formulas cannot combine contacts, if the source Contact Column is enabled to allow multiple contacts, it will pull the value through as plain text.
Can you make sure that this is un-checked in both columns:
Thanks!
Genevieve
Genevieve P.
Disable Form Submission
Hi all,
I am trying to create a form where people need to make requests by 10 out days or more. The form will be continual, year-round, so I can't just take down the form or put a due date, since this form request is never ending.
Is there a way for me to set a condition that if you're within a certain range (i.e. less than 10 days out) or if you answer a question on the form a certain way, that the form will not let you submit?
Thanks!
Dominick Vargas
How to use conditional logic to hide "Submit" button
I'm using conditional logic to show elements of a form. But if they answer questions in a specific way, I don't want to show the "Submit" button, I want them to make a phone call instead.
Is there a way to hide the submit button or otherwise make the appearance of the submit button appear based on conditional logic?
darrink
Re: Grant Management System template
Hi @TracyBe
From the image that shows the "structure of the solution", it seems this solution is using Smartsheet Control Center, which would be an add additional purchase on top of your Smartsheet plan. See:
It looks to be quite a complex solution, so I would recommend getting in touch with a Smartsheet consultant if you need help building it out and want to talk to Smartsheet staff.
There are simple templates in the Solution Center that you can use as a starting point that only use the core Smartsheet application (no add-ons needed).
Here are some examples:
Grant Fulfillment Tracking
Grant Application Plan
Project Portfolio
Benefits Tracking
Project Schedule Management
…and more!
Cheers,
Genevieve
Genevieve P.
Re: Heat Map
As data sets become larger, Heat Maps have become a critical tool in data visualization for data engineers and scientists - specifically (not a complete list):
- Visualizing Complex Data: Heat maps are great for visualizing large datasets by depicting the density of values in a matrix or grid format. This makes it easier to understand complex data patterns that might be difficult to see in raw, numerical data.
- Identifying Correlations: Heat maps can help identify if and where correlations exist between different variables.
- Highlighting Extremes: Heat maps use color gradients to represent data values. This allows for quick identification of high and low extremes in your data set.
- Spatial Analysis: Geographic heat maps can show the geographic distribution of data..
- Simplicity: Heat maps simplify complex statistical analyses into understandable graphics.
- Comparability: By placing different heat maps side by side, one can compare different data sets effectively. This is useful in A/B testing, marketing campaign analysis, etc.
Adding Heat Map Graphs to Dashboards is now common in most software packages (i.e. Excel, Tableau, etc.).
Please confirm if Heat Maps are on the 2024 Product Feature roadmap.
Michael S.
Restore deleted automated workflows
Hi Guys,
i accidentally deleted an automated workflow (automation) created by an co-worker on a sheet.
Is there any way to restore it? I already checked the activity log and see the creation and deletion of the workflow but no way to recover it. I am the owner of the sheet.
Thank you in advance.
moritz
Re: how to send 2 different forms
Hi @MBurdman,
Your idea of using columns to trigger ‘scripts’ or workflows is a great idea! I’d suggest creating one dropdown column with two options. Then, you could set up automated workflows on your sheet, based on a date column in the sheet (set the trigger to When a date is reached and select Date field, then select the date column from your sheet you want to use).
You can then add a condition block and set it to use your dropdown column, saying “Where [dropdown column name] is [Option 1], then set your action block for that condition to send the relevant form link (see Manage and distribute a form for information on how to copy a form URL, and see Customize your alerts and requests for information on setting a custom message in the action block).
Next, you can add a condition path in the workflow and set it to when the dropdown column is the other option, and an action block for that condition to send the second form.
Your workflow would then look something like this:
Alternatively, you could set up separate workflows if you’d like the trigger to be different for each workflow (for example if you’d like one workflow to trigger based off a change in a row, or to run once a week, or based on a different date field in the sheet). For more information on triggering workflows, take a look here: Trigger blocks: When your workflow is executed.
Hope that helps!
Georgie
Georgie
