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…
here is the data which I had in the summary sheet. can anyone please help to create a dash board with individual health charts?
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…
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…
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? and if they update in the shared sheet automatically it should update in the main sheet. is there any process?
What process should we use to automatically alert the contacts in that row about the status 3 days before the PP planned date?
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
Just as the title says. It's really frustrating when you want linked cells to trigger a workflow but you can't.
Hello, I am working on a table and am using a countif formula that references another sheet. I then want to copy paste this same formula across a few more cells but would like to change the reference column for each new cell. However, when I change the reference column on one cell, it then updates all instances using the…