-
New Comments Format
My team has run into HUGE problems over the past couple of days because of the latest change over from discussion to comments. We have teams in different countries communicating with each other though the discussions. We had previously used separate discussions (on a single row) to communicate approvals needed from…
-
Formula help - if cell is blank, checkmark cannot be checked
Brain cells are missing. I've looked through the formula examples and can't seem to put together the formula I need. We have a column that needs to have text in it before the Checkmark column should be marked with a check. Here's the scenario: IF column B is empty, checkbox cannot be checked. This will help our team…
-
Align Gantt chart with Timeline above?
Hi All: I'm a new user...Ihope this question is not too silly? The horizontal timeline above my Gantt chart is several days off. How do I get it to properly align with the Gantt bars below? My start & finish date columns are correct and the calender view shows the correct dates. Thanks in advance.
-
Electronic Approval
Have a project tracking sheet that we want to capture customer approval thru Smart Sheet. Would like to have a time stamp and lockdown of the field once they approve so that we have documentation. All we can do right now is send notification thru SS to update the line with approval and get the approval e-mail back and…
-
Subtotal Formula
Hi, I want to take the subtotal of the rows, after applying filter. in excel I was using =subtotal(9, C2:C100), where C2 to C100 are the data field. I tried to apply the same forumula but not working on smartsheet. Is there a way to calculate subtoal of the filtered rows? Please guide.
-
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.