-
Is it possible to get a weeks beginning/ending dates from weeknumber?
I have figured out a different set of formulas to get a beginning/ending date for a specific week and month. But have been asked if its possible to use the following: =countif(range, Weeknumber(@cell) = Weeknumber(Today()) to meet a date range criteria (something similar for month). I've tried the following with no…
-
Cell Linking not working
Good Afternoon, I have a report which collates all monthly figures from each Months Tab, and links them into a Detailed Yearly Report for my figures. This is starting from 2018, but ive got down to March 2019 and now the Linking doesn't appear to work. No matter how I do it, the link doesn't show inside my column. Is there…
-
Question on multiple predecessors
Hello! When using 2 predessors for one row, smartsheet calculates the later start date. How can I manage to get the earlier start date. For me it sounds like a common requirement. Start as early as necessary to meet 2 alternative deadlines ... Kind regards Michael
-
Assign a last history of the cell into a column
Hello, I would need to track a lead time of request approval. I keep those approval status from several approvers of 2-4 people in the cells. I understand that there is a activity log report. however it still needs manual mapping to identify each approver timestamps and calculate time lag. My goal is assign a last activity…
-
Resource and pooling resource.
Hi, Does everyone allocate tasks to individuals, or does anyone use a resource pool? for example, if you build a project and need a Quality Engineer allocating to the project, can you allocate to a Quality Engineer pool to show you need a Quality resource, and then allocate the correct named resource later, when you have a…
-
Displaying formula sub-components values (Like F9 in Excel)
Hi all, When having a long formula in Excel, I know I can highlight a part of the formula, press F9. The value of the subpart is then returned. Is there some way to do something similar in Smartsheet ? Best,
-
Gantt chart, how to color weekends in OTHER colour than grey?
I have seen some post regarding the possibility of changing the colour of the columns marked as "non working days" and all suggestions to solve this seems to point to the possibility to change the colour of rows. So, I am again asking about the possibility to change the the colour of columns to enhance the readability of…
-
stopping messages
Hi all, I'm new to this Forum. Does anyone know if there is a way to stop a message send out of smart sheet. I know how to cancel an update request but cannot find how to stop a message send that is still in the queue thanks
-
Resource allocation not matching project sheet allocation
A member of my team is allocated resource on a project. The issue is that although they are only allocated to 85% on this project/task, it is showing as 100% in my resource view. I only have view access to the sheet and cant change that but am confused as to why this would be doing this
-
SUMIF problem - "#incorrect argument set"
Hello, I am getting the "# INCORRECT ARGUMENT SET" error when using the following formula: "=SUMIF({Treads Extruded 2019}, MAX({Week no.}) = [Current wk no.]1, {Production Qty})" I have attached an image of the table I am working with, removed any sensitive information. I want to add all of the production quantity up for…
