-
Incorporate two data sets in one if/sum statement.
I have one column where I want to sum the total amount of days of work, however, I want the sum column to be dynamic based on the %Complete column if the percentage is <100%. I want the Sum column to show a total value anytime the % Complete is less than 100%.
-
Linking blank cell
Hi, I am not being able to link a blank cell to another sheet. My goal is to make data of few columns of other two sheets identical to the data of master sheet, where my team will fill the cell with data later [Currently it is blank] OR is there any way that i can link the column itself to another sheet ? Thanks. Deepak.
-
Using Calendar Days but, not including weekends or holidays for my end dates.
I believe that I may have asked this in the past but, in the legal profession we use calendar days for calculating dates but, do not want the completion dates for most tasks to fall on a weekend or holiday. Any solution to this? I came up with some fancy formulas to do this but, because Smartsheet uses its calculated date…
-
Report is pulling correct results, but cells are blank
I have a set of project sheets that all share the same basic layout and format, AND also have all the same sharing permissions -- specifically, I am the owner of all of them. I'm trying to generate a report that shows me all sheets with an End Date in the future for a specific task / row in the sheet. The report seems to…
-
Sending auto update request based on % completion
Hi, I want to send update request automatically to shared users of that particular sheet after the % completion column is 100%. Please guide me, how it is possible. Thanks.
-
Including pictures while sending update request from row
Hi, Please guide if there is some way I can include pictures [which was uploaded earlier on row] while sending the update request within my contacts. We are using smartsheet for construction project management and I want to update the row to contacts with pictures attached in that row. Thank you. Deepak.
-
Duplicating a sheet has doubled each resource usage
I have created a sheet of activities and then allocated resources to each task as normal. I then wanted to keep this sheet as is, as a template. I made a copy of this sheet to do some "what-ifs" scenarios on this sheet and keep the original intact. However in the Resource View, each resource is picking up the utilisation…
-
Is it Possible to See My Update Requests Across All Sheets?
My team and I have a lot of projects going on simultaneously. I send them update requests on a regular basis, but I can't seem to find a way to see all of my pending requests at once. For example, if I'm meeting with a Project Manager, he or she may have 10 to 15 different projects going on.... It would be great if I could…
-
How To View Projects To Which I Am Allocated
Is there a way to see all of the projects to which I am allocated? In Resource Views, I can see that a resource is allocated a certain % to 'Other Sheets' but cannot tell which ones as they have not been shared. I'd like to have these resources tell me which 'Other Sheets' they are allocated to so that the allocations can…
-
Multiple discussion for one row - MISSING
Hi, Since the last update it is not possible to make more than one discussion per line. Please make this undone. I'am really unhappy! Best regards
