-
How to get updated dates in CC Summary Sheet
Hi, I am trying to set update the summary sheet for our Control Center blueprint to show dates from the project plan rather than the original dates entered in the intake sheet. The new dates are captured in the summary data on our schedule sheets, and are selected as profile data (as date types), but they don't appear in…
-
IF(OR(Find Statement
I am trying to build a formula that searches in a column for a certain word using FIND( and I would like to add OR to that. I am using this formula and it is working fine: =LEFT([Address]@row, FIND("TZ", [Address]@row) - 1) I would like to add FIND("GZ" so that it returns either after finding "TZ" or "GZ" Thank you!
-
Report Names, Dashboard Titles and Widget Names with non-static strings
The name of reports, dashboards and widgets are limited to static strings, so the user will only know the name of the report and not what information is in the report. Example: The External Appeals Report title cannot be automatically updated to Q1 2022 External Appeals Report. Having automated strings based on the report,…
-
Text to Columns: Getting rid of letters in between numbers
Hello, I have this date in this form 2022-08-21T02:04:38Z and I am trying to get rid of the letters 'T' and 'Z' in the middle of the date. Thanks.
-
Can I automate emailing attachments?
I have an approval automation set up but it does not send the actual attachments when "alerting someone." Is it possible to create an automation that emails the files that have been added to rows? If not, has anyone found a workaround? I've seen others post the same problem, but I haven't found a solution yet. Thanks!
-
Can someone help me figure out why my multiple IF formula will not work?
=IF([PO Type]@row = "Standard With Quote", [Quote Amount (ESTIMATING)]@row - [PO Amount Including Change Orders ]@row),IF([PO Type]@row = "Non Standard No Quote", [Original PO Amount (Labor Only If Req) (PO Admin)]@row)) Everything is fine until I add the second "IF" statement. Thanks in advance.
-
Can't add a column to a sheet
I have the paid version (for years) of Smartsheet. For some reason on one of my sheets, I cannot add a column. Any help? Thanks! Jennifer
-
Sticker for ENGAGE 2022!
I wanted to showcase the sticker I created for ENGAGE 2022!
-
Countifs in date range and value range.
I am stuck on this formula, it doesn't become unparseable but it doesn't result in an accurate count. My goal with this is to is to keep an annual tally of a specific age range of patient the formula is as follows: =COUNTIFS({Trauma Chart Audit Age}, <15) + COUNTIFS({Trauma Chart Audit Age}, NOT(ISNUMBER(@cell)), {Trauma…
-
Formula for Milestone Health
I'm trying to figure out a formula for "Site Health". Each site has 9 milestones that will have a "Milestone Health" column. Each milestone must be completed a certain number of days before the project end date (October 31-22). I don't know how to create a formula to make the milestone health Green, Yellow and Red. At the…
