- Merged: More Color Options for Background and Text (Grid and Conditional Formatting)
This discussion has been merged.
- How to Design My Smartsheet App
I work for a Hospital and I am creating an application to track employee health details such as vaccinations, annual health reviews, health exams, etc. For example, employees are required to get a flu shot each year or a waiver. Employees also have to take certain tests when hired such as a chicken pox test and a color…
- How to set a formula for 3 different values to prevent any duplication
Hello Everyone, I hope all are doing well. I'm facing an issue to find the suitable formula to my case taking into consideration i'm a newbie here in smartsheet and would appreciate your kind support. The formula i'm looking for is targeting 3 main columns : Start Date, End Date & Facilitator. To assure that if a…
- Check box formula help!
I am wanting to set up a formula and/or conditional formatting so that when you check one box, it automatically un-checks another. example: two columns side by side. one titled "job started" the other titled "job done." I want it so as soon as you check the box for job done, it removes the check from job started. This…
- Automatic WBS Numbering
我们有一个工作在布鲁里溃疡t it takes multiple helper columns and complex formulas. You need WBS numbering 1 1.1 1.1.1
- View settings for shared sheets aren't working
I have created a WorkApp with multiple sheets and reports and from my pov I have the option to toggle between the views Grid, Gantt, Card, and Calendar but I shared it with my team and they are ONLY able to view it from the "default" view setting that I set for that specific sheet/report. Theirs doesn't even have a drop…
- Is there a way to save and recall sheet layout (i.e. column visibility, order, width, etc.)
I provide updates to different groups in PDF and Excel format. Not all columns are visible to all groups, and they aren't always in the same order for all groups. I'm wasting more time than I would like unhiding and re-hiding specific columns, dragging the columns into the right order, and then setting the column widths,…
- Pulling multiple information from one sheet to another
Hi everyone! I need to calculate some information based on several criteria. I have a sheet called Quality and in it, there is a lot of information. but the columns i need is; Date, Product type, Good quality and total quantity. In the product type collums we have 3 different products, but we only need 2 for this…
- Typing Minutes of meetings directly in dashbord
HI all We do our meeting with a dashboard a couple times a week. We have a chart that shows the development of all our current projects and products. Sometimes we need to write notes to the projects, (which we have a grid for in the project folder), but it would be great if it was possible to write notes directly into that…
- Clickable phone numbers in reports
I need to have phone numbers clickable so we can click a phone number from our phone rather than copy/pasting it. Is there a way to do this? I thought embedding some html code would be an option, but that's not working. It isn't a link when viewed in the report, through email after being sent, or on iPhone or Android.…