-
Need help creating a formula that will remove a certain string of text.
My use case is: I need to remove everything within the parentheses and including the parentheses. Is this possible? I just need the name. I feel like the Replace, substitute or mid formula would put me in the right area but not able to figure it out. Ex: John Doe (123456789)
-
Make Smartsheet templates that are superior to the competitor templates you provide
I can't tell you how many times I cannot find a template in Smartsheet so I turn to google. Then google finds a match on Smartsheet.com GREAT! right? No. It points you to somewhere like this: ..and on this site there are NO SMARTSHEET templates for those things! WHAT?! This is terrible marketing. You're basically is…
-
Calculating Averages with Different Columns
Hi - I am trying to calculate average based on different columns, example… Sandra A - TTL Seconds + Kelly B - TTL Seconds + Meri - TTL Seconds + Coen - TTL Seconds = Average of those numbers for each row Does anyone know the formula to do that?
-
Formula SumiF
Hello. When I use the sumif between different Smartsheet and de column is formula the result not calculated but when put the value the formula sumif is ok. like attached. WHAT IS THE BEST FORMULA ABOUT THIS CASE? SumIf between two Smartsheet's, but both columns to search use formulas don't use absolute value between…
-
Unable to use formula based date column in gantt/timeline
Any workarounds welcome. I'm importing some task data using Data Shuttle. The task data includes Created Date, Start Date, End Date. We want to use a column formula to set the start date (if its empty) to equal the Created Date. Easy enough.. I renamed the incoming Start Date column and added a new Start Date date column,…
-
Field in form is not auto-populating data, why?
I have a smartsheet 1 and smartsheet 2. After filling values in smartsheet 1 using a formula, I get an URL for a form (saved in smartsheet 2). This form is auto populated with data from smartsheet 1 for some fields. All the required fields are getting auto-populated except one, let's say, XYZ field. The data type for this…
-
Anyone else experiencing EXTREME delays with cell linking?
I'm noticing SEVERE delays with cell linking lately. As in over 15 minutes before the cell populates. Our plan includes tech support, so I called yesterday. They said "up to 5 minutes is normal" I'm at over 15 minutes with no data being pulled down from the other sheet.
-
Is there a way to set the default custom color palette on a dashboard?
We are not a part of the EAP program and recently noticed a new default custom color palette set for net new dashboards. Not seeing any documentation outside of logo and task/background colors that a sys admin can set at the plan level. We would prefer that this be set to follow our company approved colors. Is this a newly…
-
Archiving Rule in Control Center Not Working As Expected
I have several completed projects located in an intake sheet that I would like to archive. I created an archive rule for projects with a status of "Ready to Archive" to move to a separate workspace. I also checked other freeze & disable features for items. When I tested one project, the only thing that worked correctly was…
-
Why am I unable to see attachments made in a comment in Dynamic View?
When an attachment is made to a row via a comment, I am unable to see that attachment in the details panel of a the dynamic view. If the attachment is added as an independent attachment I can see it in the details panel > attachments.