-
Receiving Error Message, 'app.smartsheetgov.com refused to connect'
Within my dashboard I am getting this error message, 'app.smartsheetgov.com refused to connect' where my form widget is embedded. I have tried to refresh, I have tried to re-paste the url, I have tried using the embedded code for the form instead, I have tried recreating the form from scratch...to no avail. Anybody have…
-
How do I co-locate my smartsheets so that they appear together in a grouping of some sort?
Hi! Here are 2 analogies to help explain what I am trying to ask: MS ONE NOTE allows you to organize the note "pages" of your choice into a single "notebook" construct by placing the notes into the various "sections" of the "notebook". All pages are at your fingertips by opening the "notebook". MS EXCEL allows you to…
-
Large Project
Hi, I am PMing a project for which there are countless details and deadlines. I have created a report that speaks to 11 other sheets. Each sheet is a branch of the project, e.g. Finances, delivery schedule, etc. This worked, but was a lot of information to comb through, does anyone have templates or any ideas on how to…
-
Average value between two dates.
Hi, I have generated a report from different project sheets. I have a column (C) which has dates when a particular task is completed. Column D calculates the time taken to complete that task (Turn Around Time - TAT). I want to calculate the average TAT taken to complete a task in the month of Feb. I am not able to put two…
-
Modifying Single Row in Report, Modifies all records in Source Sheet
We have a custom made Resource Management tool setup in Smartsheet, which consists of one Sheet and a few Reports used to track and manage resource assignments. We noticed recently that if someone (not me) modifies a single row through one of the Reports, Smartsheet is changing the Last Modified date/time and Last Modified…
-
We are using the automated column Date Created to monitor when requests are made employees.
The date and time is not populating with the date and time the employee entered the information. I created the sheet, I am in Eastern Standard time in the US. Our employees are in Kenya. I transferred ownership to someone in Kenya hoping this would fix the problem, but it is still not using Kenya (EAT) time to populate the…
-
How to Multi-select column show on Calendar
i have a multi-select column on the sheet summary report. like to show the selection selected from the multi-select column to show on the Calendar app and add filters from the multi-select column. any suggestion?
-
If statement that subtracts current mileage from last time gas was purchased
Hi. I have a vehicle check-in/check-out sheet which lists the various info like who checked in and out the vehicle, times, dates, etc. In this sheet, we are asking if gas was purchased, and if so, please take a picture of the gas receipt which is submitted to the accounting department for reimbursement. So I already have…
-
Report not combining columns
I am trying to build a report from 3 different sheets. We have checked and double checked to make sure the column names are identical. But each time I try to build to report, the columns don't line up. We have two different columns named "Team" and two named "Quarter" and so on. Two of the sheets seem to match up in the…
-
data shuttle or zapier?
Hi, I was hoping to have a 2 way sync between smartsheet and (best case) google sheets or (less preferred) Excel. Data shuttle can only offload to excel and I guess you need to set up an offload, separate from an upload so if you feed smartsheet AND excel with new data this might lead to conflicts since it only updates…
