-
COUNTIFS formula not calculating correctly in 3 of 4 columns- I'm at a loss
What is wrong with my formula? I need it to return the number of times it finds a certain answer from a drop down list for a specific facility between 2 dates. The dates we are searching are from the first of the current month through yesterday. Ex. if it's March 13, 2024, I'm looking for data between March 1, 2024-March…
-
How to create health columns individually in a dash board ? using donut chart or Pie chart?
here is the data which I had in the summary sheet. can anyone please help to create a dash board with individual health charts?
-
Is there any way to hide a cell value within a grouping?
The two cells I have marked above in red are % calculations of the rows within their groupings. Is there any way to modify just those two cells to leave them blank? I use that column to calculate %complete of a project but I don't need to show the total % in the headers of the group. I also want to leave my groups as…
-
VLOOKUP Formula Help
Hi everyone, I have two sheets: one is a training requests log and the other is a feedback survey. What I am trying to do is pull the "motivation reason" from the Training Requests log to the Feedback Survey sheet. My idea for the criteria is: IF the "Name" and "Internal Course" (Training Log) match with the information…
-
How to capture Actual Finish Time for a Cutover Task
I have created a cutover Plan in Smartsheet and all tasks in the plan has these columns : Task, Duration, start Date and Start time, End Date and End time, Actual Start and Actual Time, Actual Finish Date and Actual Finish time. I am able to calculate start and end dates based on duration but I’m only able to capture…
-
Is there any option to share some selected columns in the sheet?
Is there any option to share some selected columns in the sheet? and if they update in the shared sheet automatically it should update in the main sheet. is there any process?
-
how to alert contacts in the row when the Planned date is about to reach?
What process should we use to automatically alert the contacts in that row about the status 3 days before the PP planned date?
-
Formula column disabled (greyed out)
HI, i'm new to spreadsheet, currently i'm on trial version (30days Trial) planning to buy after using it like one week, yesterday i've noticed i cannot convert text/number column into formula column it's greyed out. i've tried with different sheets different cell types it's still greyed out, please help out. Thanks Vinoth
-
Control Centre: new profile data is not cell-linking in the summary sheet
I have added 3 data sets via global updates, the columns appeared in my summary sheet automatically as usual but the data itself isn't auto cell-linking like it has previously. I have made sure the column types are dates as all the data is a date. I have removed all column formulas from the summary sheet as requested. I…
-
Date calculation formulas are not working properly.
Hi, community. I have a weird problem with my metrics sheet and the dashboard linked to it since it is displaying fault information with a specific formula. I have tried a lot of workarounds, including the update of both source and metrics sheet and a lot of different formulas but I can't still fix it. Formula is as simple…
