-
Due Date based on Priority and Date Submitted
Hi, Was just after a bit of help with a formula I am trying to produce. We have a sheet with a column 'Priorities' of Low, Moderate, High, Extreme. We then have a column titled 'Date' I am trying to automate our 'Investigation Due Date' by IFS formula. That is priority is Low or Moderate the Investigation Due Date will be…
-
Gantt chart on Mac OS while using Firefox and Safari
Hello, I have the problem that on the trial version its not possible to click in the middle of the sheet and pull the gantt chart wider. Is this a trial thing or is it just not possible to do it on a Mac OS while using Firefox or Safari? Kind regards Arnis
-
Parent row inheriting status from its children
Hi. I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons. I'd like the parent row to inherit the worst case summation of the child rows. E.g. if the child rows are red, green, and green, the parent row would show red. E.g. if the child row…
-
Subtract weeks for lead time with notifications
I'm trying to subtract 6 weeks from my Factory Shipment Date (row 1) to give me lead time to notify Port Authority which is assigned to someone on my team. I have 15 categories/columns like this with 4 team members. The categories need a lead time of 6 weeks, 4 weeks, 3 weeks, 2 weeks, 1 week or 3 days. This is for a huge…
-
Smartsheet and the Elusive Roadmap
Dear Smartsheet users, A few months ago, we made the decision to remove our public roadmap, which has caused frustration for many of you, particularly in our Smartsheet Community. We removed the roadmap for a few reasons - as priorities and resources change, we couldn’t give the expectation that the roadmap was set in…
-
Filter out multiple companies
I have multiple customers, some of the companies are listed more than once because they contain different data. But, I also need a filter to filter all of them out except for one, is that possible?
-
Time Tracking
I thought I would share my take on tracking time in smartsheet. Use the checkbox and save features to test the formulas out and see how they work. https://app.smartsheet.com/b/publish?EQBCT=77c33874736d40a78495cf4d4169365f Of course this would be useless were the current time and not just date to be able to be used, but…
-
Filtering Older Data
I was wondering how to use smartsheets to filter out older data in a log. For example in a purchasing log, what I did at first was creating a checkbox column with cells such that a order that arrived for longer than 2 weeks will be filtered out: =IF(AND([Last Modified]1 < TODAY(-14), Status1 = "Arrived"), 1) That function…
-
Workspace Ownership Change Notification
I would like to be notified when ownership of a workspace is changed from me to someone else.
-
Sharing - keeping info confidential to relevant parties
Hello, My colleagues and I have a large database containing information regarding suppliers. I need to share the information that is relevant to each supplier, with that supplier. I can obviously run a report to pull the data out based on 'Supplier' column in our sheet, as there are a large number of suppliers on this…