-
Use of the system column to get the modified date
Hello everybody, I am trying to automate the input of the modification date of a particular cell on my sheet. I figured that since this information is already available in the system column [Modified] - I'd like to take that info to put it into another cell (with Date properties) Thanks in advance for the support Chris
-
Dependency Settings specific to each day
Is there a way to allocate specific hours on individual days e.g. Mon 7 hours , Tuesday 8 hours etc
-
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…