Hi I need the date to be in the format of yyyymmdd so that I can concatenate with other cells to form document name. Otherwise, it would be manual process for me to go through every single documents to name them. Currently my settings is set as English (UK), the date format is dd/mm/yyyy. Is there a formula to convert this…
Changing outlines of Gantt chart bars
Hello, I would like to change the colors of the outlines/lines around the bars for sub-activities in the Gantt chart. I was able to change the fill color but the outlines are still light blue. Is there a way to change the color of the outlines? Thank you very much! Kind regards Ulrich
ISBOOLEAN help please
Hi Team, I have a formula that calculates tax automatically as I enter the amount. I wanted to add Checkbox column, when I tick the box it removes tax and if its untick it continues with original formula. =IF(Status1 = "WON", [Value of Jobs Including GST]1 - DepPaid1, ""),ISBOOLEAN, [Value of Jobs Including GST]1-[GST]1
Project Plan views / Task assignee see's just their tasks
I have read posts where it says to use project plan FILTERS or create one off REPORTS to execute this requirement. This seems inefficient and each option lacks what the other provides. NEED: I want an all in one feature within a project plan where I can set 'resources' view permissions based on when they're assigned a task…
How can I select data that is older than 365 day?
How can I select data that is older than 365 day? =COUNTIFS(Product:Product, "ABC", [Project Complete Date]:[Project Complete Date], "Where Project Complete Date is < 365 days from today"
Change RYG Automatically based on values
Hello – I am trying to create a formula that will change RYG automatically with the following criteria: Green: Any positive (%) Yellow: 0 to negative 10% Red: less than negative 10% With the below formula, green and yellow work fine but not red. How close am I? =IF([% OVER (-) UNDER (+)]5 > 0, "Green", IF([% OVER (-) UNDER…
Row Attachment: Link (URL)
I use Smartsheet to track video production in my department and there is a request to associate video links (vimeo urls) to each project row. I've tried creating a whole new column containing a hyperlink, but that clutters up the master sheet and its information is not benefitial to sorting or report generating. The other…
Is there a way to make templates for Forms and then add them to each of our projects? I see where you can build forms and then clone them inside of a sheet but we would be looking to copy those forms into other sheets. Is there an easy way of doing that? Thanks!
Time Tracking - Formula needed to total time spent
Has anyone used SS to track actual time spent? I am using the "Time Track for Client Projects" template modified for simple tracking of time spent for individual tasks by client or department. I cant seem to get the formula needed to add the columns for Start time & Stop Time to calculate and provide a Duration for actual…
for two criteria query should I use LOOKUP or INDEX MATCH
I need to populate the low range based on a match to a specific specialty and tier. The specialty is just a drop down but the Tier was based on the following IF formula: =IF([Points Total]11 <= 15, 3, IF([Points Total]11 >= 16, 2, IF([Points Total]11 <= 45, 2, IF([Points Total]11 >= 46, 1)))) * Question 1: Should "…