-
Create additional dependency column to facilitate auto roll-up to parent
I created a new column "Effort". I want the "Effort" rolled up to the parent. That is not happening. One of the FAQ states that column must be a dependency column. However, I can only see "Predecessors" and "Duration", when I go to <Project Settings/Dependencies Settings> One way is to add a formula in the parent cell is,…
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
Include Cell Data in a reminder
Hi guys Just checking as I dont seem to beable to add cell data within a reminder/email. I.e, say I wanted Row One "Name" to be the name of the recipient in a "Hi [NAME]1, TASK X is now complete." I tried JavaScript way "Hey " + [NAME]1 + "Task X Compelete" but not sure of another method of doing this. If anyone could help…
-
Smartsheet mobile app
Is there a way to dial a phone number on a sheet staright from the mobille app on Android?
-
Creating a formula that relies on conditional formatting
Hello all. This may be out there, but I am not really sure what search words to use, so haven't had much luck in seeing if anyone else has come up with a solution. I am trying to create a formula that will calculate the sum of all cells in a column that meet a specific format, in this case, shading. I do not want to have…
-
How to submit a Template to be Shared in Template Category?
Hi! I have created a tax season client template that would be a great addition to the finance category. Travis had requested that I share so please advise on how I can share with the SmartSheet community. Thanks!
-
Mandatory Cells
I've done a formula to add "date required" when the box is checked and " " (blank) when date is not checked. Issue is when the user puts the date in the field, it removes the formula, so if they unchecked the check box, or remove the date, the date remains blank. Although I have formatted the cell to stay Red if blank, I'm…
-
Aging Items Based on TODAY
Hi, I'm trying to use the TODAY function to work out the age of an item. In Excel I would have a cell with =TODAY(), and do a calculation to subtract the date of the item from this. I have tried using =TODAY(), =TODAY, TODAY, TODAY(), but can't get it to bring back today's date (got #INVALID COLUMN VALUE, #UNPARSEABLE or…
-
Combining COUNTIF and COUNT(CHILDREN) formulas
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
-
IF(AND(DATE(YEAR
Hi Team, If(and( this MONTH/YEAR date matches the [Comms Due Date]2 MONTH/YEAR date then return 2% of [Current Month Sales]2 dollar value or nothing. (Text number cell) =IF(AND(DATE(YEAR([Comms Due Date]2), MONTH([Comms Due Date]2), ([Current Month Sales]2,*2,''-"))))
