-
IF FORMULA TO PUT AUTOMATIC STATUS
I would like to know what can I do to put automatic status for my monitoring sheet? There are 3 status: In Transit, Cancelled and Delivered. I want to know if its possible that when the requestor input the delivery date (refer to the screenshot), the status will change to "Delivered". For the Cancelled and Transit though,…
-
Select All/Unselect All for Outlook add-on attachments
I am curious as to whether there are others who would like to see a Select All/Unselect All for Outlook add-on attachments? I submitted an enhancement request but wondered if anyone else would like it or if SS is making me too efficient and I want less clicks .
-
Jira connector
Is there a way to create a template of the field mappings for the jira connector? We would like to establish a standard mapping for a set of our projects and we are looking for a way to either clone an existing workflow or upload a template.
-
How to create a future date based on a date in another column?
Hi, I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days. Thanks! Keren
-
Using Auto-Generated Fields in Formulas Successfully
I have a sheet which tracks all a department's projects. We are making improvements which required us to create a new version of it by copying from a previous version (save as new) which meant that the auto-generated "created" date all the sudden became the date I made the new file, rather than the date the actual project…
-
Baseline in Gantt chart
Hello, I was wondering if a visual solution to show baseline dates vs. actual dates on gantt charts is already available. Thanks
-
Widget when Pulling Reports
Hello, I would like to have multiple reports(because of the different people assigned to different projects) on my Dashboard but I only need certain columns from each report. How can I make this possible. Thanks!
-
Expired Date code
So i recently create a new Cell called " Expired Date" what I'm trying to do in this cell is to show when a date has been expired , based on the Promised Date, but i found that if i left mi code just like this, But =IF([Promised Date]4 > TODAY(0), "Expired date", "-" i don't have a restriction. And i try this code, but i…
-
Creating a Chart from Non-Numerical Data for a Dashboard
I would like to have a pie chart on my dashboard that displays percentage of types of activity from a column in a sheet. More specifically, I have a column in an IT tracking sheet that has a dropdown menu. I would like to be able to display on a dashboard the percentage of each activity in the sheet. (e.g., a pie chart…
-
Linking sheets through dropdown box
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including workplans, professional development and reporting. On each sheet I would like to be able to ask the staff member to choose their…
