-
Parent Formula to display modified child status
I am looking for a Parent / Child formula to capture a status change (R / Y / G). The Parent status will change based on the Child status Change. For example: If I change the status of "Software" to Red (R) in the child row, it should change the Parent status to Red. The parent row captures any child row that changes from…
-
Is there a way to return the row location of all instances of a duplicate value within a column?
I've created a duplicate flag column using the following formula: =COUNTIF(Email1, Email1) + " of " + COUNTIF(Email:Email, Email1). This shows the instance and the count. What I would like to be able to do is provide the row numbers of the duplicate emails. Match will only find the firs duplicate but won't return all of…
-
Highlighting Gantt Chart Date Columns
I have several projects that were suspended due to Covid issues but are starting to open back up. I have to push out everything due to this suspension and I would like to highlight (or just delete/hide) those date columns during the suspension period. Is there anyway to do that? If not, can I submit that as a feature…
-
How to Create Formula to return Fiscal Week
I have 1 column with Start Date for Fiscal year & week 2nd column is end date for fiscal year & week I want it to return 3rd column where i have FYYRWK This is all housed in a separate smartsheet. Ive tried a few different articles on smartsheet, but cant seem to get one where i want it to be = or Greater than & less than…
-
Planning Calendar conundrums
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am trying to figure out the best way to handle that. Would I only be able to do it using…
-
Time Formats - Number formats - Rethinking the UX and function
Having an entire dialog for text and number formats would make much more sense to me.. combine the currency, percentage, thousands and decimal places into it's own dialog box. We really NEED a way to save and modify the formatting of common things. So as to have them available and globally modifiable across workspaces. Use…
-
FORMULA NOT WORKING
HI, I have a formula =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue?? Please see attached excel with formula in Column D Thank you in advance :)
-
Logic formula for checkbox
I am trying to get a box checked if a completion date has been entered OR a status has been marked complete. Formula I have is =IF (Status3 = "Complete") OR NOT(ISBLANK([Real Completion Date]3)),1 What am I doing wrong here?
-
Trying to add a IF date around a countifs statement...
My goal is to only count " =COUNTIFS({ZenQ Testing Required}, FIND([Primary Column]3, @cell) > 0) " if the date is within 2020 year for the created date of the jira ticket. Can someone help?
-
Help IF/AND formula with RYG conditional formatting
How do you create RYG symbol formula that requires multiple conditions of multiple reference cells? Here are the conditions I'm trying to write a RYG formula for....using reference cells [LEADER NAME] and [RISK FLAG]: If [LEADER NAME] = BLANK, then keep cell empty If [LEADER NAME] = NOT BLANK, AND [RISK FLAG] = CHECKED,…