Dear All, I am struggling to figure out why a dynami report I set up in Control Center doesnt pull in the files. It is stubborn to keep only 1 file, instead of the 30 I think it should. Is there a set…
Hi All, While doing a global update I added new column ( type: Contact) I need to change the formula to that column. The issue is the formula is cross sheet =IF({Project Metadata (Do Not Edit) Range 3…
Dear All, would you please advise if this is possible? if yes, would that be a combination of JOIN/ COLLECT/ IF / AND? If no, is there a way around it? I need the dates in these 10 columns: to feed in…
Hi All, I wanted to check Baselines in one project that has been on hold and postponed for a while. And now I see that the columns for baseline are only filling in for some of the rows. Is there a way…
Hi, I gotten so much help here before, so once again... I have a column Total Rank Score where we assign points to each task. I want to be able to group those into 3 categories. If value is between 0 …
Dear All, Could you please help me with this formula? =INDEX({Project Plan - Task name}, MATCH([Start Date]@row, {Project Plan Range 1}, 0)) I wanted to show TASK NAME (from project plan) on the RACI …
Hi All! I am looking for a solution that will automatically copy the content of one column into a column in a different sheet. Is there a way to connect a report to a sheet in a way that will allow Sm…
Hi Everyone, I was wondering if what I have in mind is possible, maybe some one has an idea how to do this. I would like to have a calendar where I can see the sum of allocated time per person in each…
It would be very useful to be able to see in a report of some shape all the access permissions given on workspace and sheet level. With many workspaces that contain multiple folders & sheets the abili…
Hi, Happy Friday everyone! This might be a silly question, but I just realized I have this option in Smartsheet. I have Resource Managment separately, so I am wondering what is this? I cannot find a h…