-
View formulas globally in a sheet
Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying the underlying formulas). I find this very helpful to: - Discover which columns I want to shade grey to indicate that they…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Stacked IF statement not evaluating all "value if false" options
I have 6 columns of dates that outline a chronological study process: Phase 1 Forecast date & Actual date, Phase 2 Forecast date & Actual date, and Phase 3 Forecast date & Actual date. I would like to consolidate these 6 dates into 1 column ("IX Study Status") that simply gives the current study status. I wrote a stacked…
-
Correct Formula Syntax for checking for excluding blank cells
I have a RAID log sheet where I want to add a helper column to capture the aging (duration) of each issue row that has not been marked as complete (and I want to convert the formula to a column formula). This sheet is generated for each project via our control center solution so there are several rows at the top of the…
-
Any suggestions for keeping infrequently-visited sheets/reports/formulas updated with current data?
Hi everyone, I have a scenario that worked well for 3 years, but in the past 6 months or so has become unreliable: As part of a templated toolset, I have a couple of 'worksheets' (where users are visiting and making updates), a 'calc sheet' that's pulling information together from these worksheets via index formulas with…
-
Circular References and Parseable Errors with cells that contain Emojis and Text/Numbers
I'm new to Smartsheets and attempting to transfer tracker data from Google Sheets to build dashboards. I use emojis in trackers and COUNTIF formulas to summarize the data based on emoji categories. The formulas work as long as there is no other data in the cell but I get a "0" if there is any other text in the cell. Please…
-
Check box for start date and end date that fall within Today's date
Hi Community I have a check box column with a column formula to check if the Start Date and End Date are Todays Date. =IF(AND(ISDATE([Start Date]@row ), ISDATE([End Date]@row ), [Start Date]@row <= TODAY(), [End Date]@row >= TODAY()), 1, 0) This works when there is a date range, ie Start Date is 18/2/26 and End Date is…
-
Sum Collect or If Statements
I’m trying to build a formula that can achieve the following logic, but I’m struggling to get it working correctly. I have a data sheet with around 100 project rows. Each row contains a Fab Start date and a Fab Finish date (along with many other fields). Some projects run across two consecutive months. In my metrics sheet,…
-
Blocks for vacations
We use Dynamic View to report and schedule jobs for us (we don't use Resource Management). We don't use the calendar view as it would have too many assignments. I want to be able to put vacation times/blocks in so that my Ops manager will see the block as he schedules work weeks out.
-
Index/Distinct formula suddenly stopped working last week
I had a formula to list all distinct values from a column in another sheet. I was using this formula and it was working fine until last week. What could be wrong? =IFERROR(INDEX(DISTINCT({Liste de matériel Plage 1}); Séquence@row ); "") When I remove IFERROR, I get #INVALID DATA TYPE