-
Stacked Bar Graph
Is there a way to create a stacked bar graph with the new charts? Thanks! Chase
-
Using COUNTIFs with FIND & AND
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…
-
Report Viewability
So I have created several Reports and have noticed that when you add them to a Dashboard, anyone with Dashboard Access can view them as a Widget; however, When made a viewer on the Report itself, all the people see is a blank page. Do the Viewers also need access to the sheet the report is pulled from? If so then reports…
-
Smartsheet for Insurance Solutions
Good Afternoon, I wanted to check to see if there are any users in the Property & Casualty Insurance Industry and if so, could you share what you are using it for? I am a new user and still learning all its capabilities. I see that there is a large Healthcare following but not sure about the P&C world.
-
Duplicates
How do i create a formula that shows there are duplicates. I would like it to have a check box in a column showing that "Sarah Jensen" has duplicate expense submission based off Consultant Name, Date of Receipt,Total Expense.
-
Highlighting Individual Cells Based On Date
I am trying to figure out how to highlight a cell based on how the status of the "actual" column is in accordance with the "Baseline" column. Is there a formula or conditional formatting rule to implement that will automatically change the color of the cell to green or red to illustrate that it is ahead or behind schedule?
-
Why can't I merge data from 2 sheets onto 1
I'm trying to merge data from 2 sheets onto 1 sheet or even a report. I don't want to have duplicate rows w/ the same primary column though. I want all the data for the same Primary column value on each sheet to be merged into 1 row on the consolidated sheet/report. Why isn't this possible?
-
Count number of days if status is "Open"
Hello, I'd like to count the number of days from created date to today only if the status of a ticket is "Open". If it's "Closed" I'd like it blank, I'm not sure how to do this. Here is an image of the ideal results Thanks!
-
Checklist for Airbnb Cleaners
Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated! 1) This checklist will need to be filled out each clean. That means there needs to…
-
Auto-generating Google Campaign URLs with Smartsheet?
I would love to create and manage Google Campaign URLs with Smartsheet. Ideally, I would enter the URL and associated variables, and in the final column it would generate the complete campaign URL, just like the official Google URL builder (https://ga-dev-tools.appspot.com/campaign-url-builder/). Specifically, I suppose…
