-
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,''-"))))
-
Preserving Task Rollup in a report?
I would like to create a report to be sent out on a recurring basis that is essentially a filtered version of a report, (i.e. only showing tasks that have not been completed and filtered for tasks for a two week period in the future. I've been able to set the selection logic up in the report, but it does not bring the…
-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
