-
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…
-
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?
-
Counting formula to see how many status each person has
So I want to see how many Not Started, In-Progress or Completed each person has.
-
Images in Templates
Is it possible to save an image in a template. I have tried but they disappear. I have all options ticked. I understand that I can attach them but visually it would be better for a small image to be shown against the item name. Would this be something that could be done in the future to save having as an attachment and…
-
Manufacturing Scanning
We manufacture an industrial machine. As the system moves through the process at each station we would like to update the status of each machine with a qr code or a barcode, and trigger automation rules ie send emails or alert for issues if they come up. We want in the future to populate the smartsheet with info from…
-
Mark child if Parent meets criteria
Hi- I see lots of threads to mark a parent if a child meets a certain criteria, but I am looking for the opposite. I have Material, Labor, and Subcontractor Parent rows and would like to mark the children with either a number or letter indicating if it is a child of one of those parents (Material =1, Labor =2,…
-
SmartForm Problems
I have had a problem that has occured twice over the last week where I have been completing the SmartForm linked to our sheet, it closes down halfway through and loses everything that has been inputted. The browser settings are all correct and there don't appear to be any internet connectivity problems. Has anyone else…
-
Automated Alert & Action Issues
Hello I am trying to solve an issue with a system I have set up for Automated Alerts & Actions. See screenshots below. As you can see by screenshot 3, I have created a trigger column based on date surpassed; once that date is surpassed the cell will change from N to Y. The idea ultimately is when it changes to Y it…
-
Jumbled Rows
I have a Sales leads sheet shared by 4 of us. Almost every time I move or amend a row and then SAVE, the rest of the leads jumble around and I have to move every thing back. Not sure what's the problem here! Can anyone help?