-
This / previous month, / This / Previous week selectors for reports, reminders, alerts and automatin
There are hundreds administrators, who are using additional odd helper columns with formula to calculate If the month @row/cell is from this month or previous month. It would be "OK-ish", however it's impossible to use this format of calculations, when using external autopopulation sources (which by the way i'm using a…
-
Is it possible to add any form of Approval / Draft data for a smartsheet, like one would do in Excel
Hi, For compliance I really need to add Draft, Review and Approved data to a Smartsheet, by when and whom etc, like you might get on many document. I am actually trying to do a risk assessment, and had it in Excel, but I find some Smartsheet very helpful. In Excel one would just had a table on another worksheet with the…
-
Using the Duration value in a formula
I am working on a budget for a project plan and want to get the hours associated with a duration to do the math. All of the durations are input as days, i.e. 3d. Is there a way to understand in a formula that this is 24 hours. I have tried to reference the Duration column but am only getting the number the designation of…
-
COUNTIF AND Statement
Hi, it's me again.. I promise that one day I will understand SmartSheet formulas :) Trying to COUNTIF the Status is Complete AND the Phase is Rollout (will need to do this for the other four phases) =IF(AND([Status]@row <= “Complete”(), Phase@row = “Rollout”)) ^^ Does not work Tried to select the range on the sheet as…
-
Add clickable "hyperlinked" text to an Update Request Message
How can add clickable "hyperlinked" text to an Update Request Message Change this Click http://www.ebay.com to be taken to the link To this Click HERE to be taken to the link The html code is <A HREF="http://www.ebay.com">This will show as clickable</A>
-
Count IF formula
I need a formula that will count if days till due are between 0 (today) and the next 7 days AND if the status column is not complete. This is not working for me. =COUNTIFS([Days Till Due]@row > 0, [Days Till Due]@row < 8, ([Status]@row = "Complete", "") Thanks all
-
Moved: Working on formula to return the value of the NEXT CHILD row in PARENT column
This discussion has been moved.
-
Is there a way to create 'dynamic' formulas?
As I'm sure all of you deal with every day, my stakeholders are constantly changing their minds about what they want to appear on our dashboards. No biggie, I just go and modify the formulas, and all is good... until the next change... and the next change.. and the next change... So, I started to wonder if I could use a…
-
Automation: Send to contacts in a cell
Hi, I'm having an issue where an automation won't send an email. My personal settings are correct. It will send the email if I input an email address, but it will not dynamically pull that email from the submission. I.e, it's a mutliple form, and the form gets filled out by X person, who inputs into one of the contact…
-
Can I conditional format specific cells only?
I only want the rows under my "STATUS" parent row to change colors. If status is less than 0, turn red. If 0 or greater, turn green. I figured out a workaround, but it's still turning other numbers in the column green. If I try to define a custom criteria when in the rule, it only allows for specific numbers, not the cell…
