-
count cells with the same date that are NOTBLANK
Hi, I have 2 Grids (Sheets) and I would like to insert the formula in every row that counts the rows that are NOTBLANK in other sheet with the same date. Sheet1 has several ROWS with the same dates. Sheet2 has only one date per ROW. I would like to COUNT Sheet1 rows that have equal Dates and insert it in every row in…
-
Sumifs and Children
I am trying to sum the values of child row if three conditions in adjacent columns are met, from another sheet and post it on my main sheet. I reference a parent row and need to sum the children values if they meet the three conditions . Specifically, I use a cell value from the main sheet to find the referenced parent row…
-
Formula for RYG using % Complete and Finish Date
I am trying to populate my Status field, using RYG formatting (based off the % Complete and Finish Date). I am trying to use an AND/OR and it is not working for me. I can get half way there, but not completely. My Status Definitions: Gray - Not Started Yellow - In Progress Green - Completed Red - At Risk I would like to…
-
If a checkbox
Hello again. I need some help please with automation/formula on a project management sheet we use. (Action 1) I have a checkbox column called "SNAGS" When this is checked, I need a date column called "SNAG ADDED" to auto populate the date in which the checkbox was ticked by the project manager. (Action 2) Like wise, I have…
-
Ability to "lock" rows based on a response in a cell reference
Looking for a way to write a formula to lock rows if a cell has a specific value in it, or hide the rows. Any ideas?
-
How to add time to trigger update request
We have a create date/time column and a status column. The default status when a new item (row) is added is "Not Started". I am trying to take the date/time created, plus 4 hours, and if the status has not been updated I want to generate an update request. Is this possible? I read that the automated update requests can…
-
COUNTIFS formula not returning result
Hello Community! I have a COUNTIFS formula that does not return an error, but it also does not return the result I am expecting. Long story short, I am trying to count how many projects we plan to start by month and year. There are three separate columns that I am pulling from. The column that is giving me troubles is the…
-
Formulas with IF statements
I am working on if I have three sections and I only need to average one section because the other two are null, how can I write this out? =IFERROR(AVG([% Complete]73, [% Complete]76, [% Complete]79, [% Complete]82, [% Complete]85, [% Complete]89, [% Complete]91, [% Complete]92, [% Complete]93, [% Complete]94, [%…
-
Stacked Charts
Hello 1. I am new to the smartsheet community and would like to know if it is possible to plot dates using the charts widget in the dashboard. I intend on plotting a stacked bar chart with dates and duration. (As show in Figure 1) 2. While using the clustered bar charts option, is it possible to a merge the bars, something…
-
Formula Tips are Obscuring the Actual Formula
Hello, Could anyone provide a trick to move the formula tip dialogue box? I am getting an Unparseable error message, but I cannot see the formula to check the syntax (see attached screen shot). Are other people facing this problem? Is it browser specific? I am working around this by copying and pasting parts of my formula…
