-
Smartsheet for Marketing
I am brand new to smartsheet, just trying it out to see if it would meet my needs. I run a marketing unit at a university, and currently use a system called Workfront for our project management and online proofing. Is there anyone out there using smartsheet for marketing? If so, what are the pros/cons you've come across…
-
Intelligent Reminders
I'd like to see some additional intelligence built into Reminders. So instead of just "Send user a reminder 1 day before Due Date", Something like: "Send user a reminder 1 day before Due Date if..." For example: "Send employee a reminder 3 days before Due Date if Finished? is not checked" "Send manager a reminder 1 day…
-
IF statements with multiple dates
I am trying to have multiple columns with multiple dates automatically update my "next due date" column. For example I have 4 columns with 4 different dates, I want my due date column to be the last date + 90 days. For example if I have columns, A,B,C,D, and E, and all of those columns have a date except E, I would want my…
-
Resource Views discrepancy
hi! I am having a discrepancy in the resource views. It seems like the dates shuffled a little and therefore it shows overlapping in days that are not really overlap. Please advise, thanks,
-
Report not showing a row
I have a project plan with rows linked to a sheet. I am attempting to pull a report on this sheet, but the report is not pulling in all of the criteria. The project plan has a column titled "Tags", which has Milestone and Timeline. These tags are included on the linked cells in the other sheet. I Run the report to include…
-
Date Fields
I have two date type questions: Question 1 I am looking to auto populate a date field as soon as two other columns are populated. I want the date to remain fixed and not change to 'today' every time the spreadsheet if opened. The Columns Are: Date Part Fitted - this needs the date auto entered when: Part Number Fitted…
-
Set auto reminder emails to be sent out 3 days before the finish date
I'm using a Gannt view spreadsheet and creating a timeline for event work. I'm trying to figure out how to set an automation that will send an email reminder to the contact in the "Assigned To" column 3 days before the "Finish" date column. I've read a few support blogs and I'm not finding anything to help! Anyone know how…
-
Embedding a From within Smartsheet
Hi - I've created a form for submission of items in my "email calendar". Our team goes into spreadsheet often, so I don't want them to have to exit to click on URL to submit email request. Is there an easy way to add it into Smarsheet so that they can easily submit a form within our Email workspace?
-
How to make a Status row function like a Status Column
Hello! Is it possible to apply the properties of a column to a row? I want to be able to update the status of each column in a single row. I'm not able to identify where and how to do this; please see my attached screenshot. Currently, I have a column titled Status (circled in the screenshot). I essentially just want this…
-
auto date entry multiple columns
i have multiple columns in a sheet for various tasks that need to be completed (water, electric, etc.). the columns are a dropdown to pick from complete, in progress, not started. i wanted to insert a column next to each task that would insert the current date & time when the status was changed to complete. i attached a…
