-
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…
-
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…
-
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…
-
Merged: More Color Options for Background and Text (Grid and Conditional Formatting)
This discussion has been merged.
-
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.…
-
I am trying to book an Orchestra using Smartsheet Forms and Sheets, any ideas?
The form needs to go out to the pool of musicians and poll their availability. Then the availability needs to be able to be quarriable to book musicians by part. For example, I need the following parts covered each day: Flue, Trumpet, Trombone, Tuba I need a form that can go out to all the flute platers and they select the…
-
Emoji Icon Viewable When Printing to PDF
Using emojis is a game changer for tracking data and keeping data clutter to a minimum. However, in some cases, we still need to keep physical copies regularly for the sake of archives. The Issue: When printing the sheet to pdf, the emojis used do not appear. I've created a sample that does not use any confidential or…