-
Display a counter in a bar graph
Hi community, I'm making a bar graph which shows information in %, so each bar is the percentage of the information I want to show, but this '%' comes from a scalar number which I also want to display. Is there a way to do this? I attach an example.
-
Flag Red if under 100% or Past Due
Hello! Here is what I am trying to accomplish! In the column with the flags (highlighted yellow), I would like the flag to turn red when the Percent Complete Column (highlighted Green) is less than 100% OR if the Completion Date Column (Highlighted Blue) has a date past today's date. Please let me know if you can help with…
-
IF formula with Condition on dates
Hi there, can anyone help me on this formula ? it looks the only issue could be on the date format but I don't know what I have to change. =IF([Expected Order Date]4 < 3 / 31 / 18, "1Q 18"; IF([Expected Order Date]4 < 6 / 30 / 18, "2Q 18",IF([Expected Order Date]4 > 9 / 30 / 18,"3Q 18","4Q 18",)))) Thanks a lot in…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Using reports to create Totals
Hi I am pretty new to Smart Sheet and have mainly used it for Project Plans so far. I am now looking at using it for forecasting for delivery consultants. I have created a sheet and form for them to enter forecasting for delivery for a particular customer in a given month. I would however like to be able to create a…
-
Building a formula to connect multiple cells between sheets
I understand that Smartsheet is not automation tool, but would like to make team's work easier without having to enter lots of information manually. Situation is that that we have two files: pipeline and quote. Once the quote is completed, there is a series of Values, about 40, which need to be called up on the Pipeline…
-
COUNTIFS ON MULTIPLE COLUMNS REFERENCING A DATE RANGE
I am trying to summarise a Smartsheet that we log sales activities (F2F Calls and Phone Activity into). So I want to see how many Phone calls have been done in the current month. 1. What is the most efficient way to achieve this? I have used the below formula to get June Activity, but when I try and reference another…
-
Sales/Support Hours
I am growing increasingly frustrated with not being able to get in touch with help early in the morning (east coast). What are the hours that sales and support work? I can't find it posted on the website anywhere. Having to wait until midday to get a hold of anyone is really a pain and causing delays for my organization.
-
Can I set up a report to auto run?
Hi there, I have a report set up with all of our bidding projects. Every week I go in, change the date to dates greater than "today", then click "Run" so it'll only populate future bids. But now I'd like for it to automatically refresh with "today's" date every day. This way I can have it displayed on a dashboard. Is there…
-
Integration with Orchestrated Beer
Orchestrated Beer is an SAP Gold Partner - is there a way to integrate into SmartSheets?
