-
Help with Google Forms sync
Hi All, I am trying to create a procurement Smartsheet for my company, using Google Forms as a method of collecting data for procurement requests. The reason I am using Google Forms is that it has form logic, which is something the people at Smartsheets have not implemented yet, but are working on from what I am being…
-
Making bulk changes to a Sheet in multiple Workspaces
As an Admin for a Project Management firm I deploy a new Workspace as new Projects come online. Within the Workspace, Sheets feed Reports which feed the Dashboard. Each Project is a self contained Workspace. Occasionally, a formula error is picked up in one of the sheets by our users. This typically means that the same…
-
Why am I receiving automation email replies?
I set up an automation that will send a PO request to external clients. When they reply to the automated email it comes to my email address and not the person that was requesting the PO. 1. Does it come back to me because I created the automation rule or because I own the sheet? 2. If I sent an update request instead of an…
-
IF AND OR
Hello all, I'm looking to use a Created By column to auto-fill my Primary column with a specific user's first and last name. I was planning on listing each user's email and full name with some variation of a IF/AND/OR or IFERROR statement, unless there's a more efficient alternative. Here is my current and one of many…
-
Scheduling and Dispatching
I want a master calendar so I can see where our in house crew is working and other individuals so I may schedule them throughout multiple jobs. Now, we use individual sheets to gantt construction jobs. I want to find a calendar program (because SS does not have time stamp) were I am scheduling resources through out the…
-
Formula to checkbox when option selected from dropdown
Hello As per the screenshot below, im trying to have a formula that if Status A is selected from the column this will check the box within approved for construction. is this possible. Regards Daniel
-
Pull Data for Current Month
We are a construction contractor that uses smartsheet to track all of our projects. I am trying to set up a dashboard to show the current months quotes and current months jobs sold. In the past I have just run a report and then put the date between (1st and last of the month). This gets me the data I am looking for. But I…
-
Barcode Scanner not showing Barcode Picture
I am trying to update our inventory system to Smartsheets and I want to take a picture of a Barcode and instead of geting the picture of the Bar Code I am getting just the numbers. How can I go about fixing this?
-
Using multiple working days/resource schedules in the same project
Hello, As a construction PM, one of the functions I use most with SS is the Gantt style programming. I have multiple crews on the same project/in the same sheet, but the issue I have is they each have a different working schedule - for example night shift is Sunday to Thursday night, day shift is Monday to Friday, and some…
-
Summing IF and After 7
Hello, So I don't even know if this is something I can get a formula to do, but I am trying to get a number to check a cell reference and start summing if the number is above 7. But here's the kicker, I don't want it to sum the entire amount. I want it to essentially sum the number, minus that 7, but only sum the numbers…
