-
Unsubscribe from email alerts
Does anyone know what actually happens if a user selects the unsubscribe option when they receive an email alert? Many of our alerts are not necessarily optional I don't want users to be able to just opt out of them at will. I selected this on one myself to see what happens, but I can't find anywhere on my sheets or the…
-
Is there a way to re-designate the primary column after a Smartsheet has been developed and populate
I would like to switch the information that is displayed in the calendar view to data that is present in another column within my sheet.
-
Creating an automatic Change Order
I was wondering if there is a way to create a change order in a smartsheet so we do not have the type everything out and it will auto populate pricing?
-
Importing Spreadsheets with Vlookup from Excel
Is it possible to import a spreadsheet (with a few sheets in it) which has Vlookup and other formulas? Doesnt anyone has done it? I have just signed in for a free trial... it looks like I have to do all the hard work again in terms of formulas (in special Vlookup)... if so, see little benefit in using this. regards, Jandir
-
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…
-
Construction Calender
Hey Everyone, I'm trying to build a Job Calendar. I've input the dates and split it up into Man Days and Man Weeks. My dilemma is this: I need to be able to select a range of dates (ie Jan 1-8) so we can see our expense for that specific week. I've searched everywhere and cannot figure this out. Any help or suggestions…
-
Manpower Tracking with Projects
I am trying to set up a way to track manpower 50+ people plus projects that are ongoing. 2 separate sheets are fine - 1 project summary and 1 manpower. How can i set it up, that i can see who is available, when workers will be on vacation and it will notify is someone is booked for one project so i can't double book them.…
-
Auto Flagging Yes or No answers
Hey everyone! This is my first post on smartsheet, so please bear with me. I'm trying to build a Production Report. I'd like the Red Flag to turn on whenever the "Was Production Met" column says "No". This is my current formula: =IF([Was Production Met?]1 = 0, 1). I can make it work with a checkbox, but no luck with yes or…
-
Cross sheet formula/reference
Hi everyone, This may be a basic answer, but I am trying to build a dashboard for my company. I have 6 reference sheets that I want to filter into 1 large sheet (the dashboard). The dashboard is an accumulation of weekly data that the 6 sheets feed into. Each sheet has a different employee inputting different data. So, If…
-
Baseline
How can I establish a baseline in smartsheet? I am using smartsheet for construction scheduling. Like many industries there are delays. However, in construction delays come with a cost, a dollar amount that needs to be paid when projects go over their time line. I establish my schedule when I start a project. Throuhgout…