-
Workspace Cell References
It would be useful if you could create / manage a table of workspace cell references. For example, I have a base sheet that then is referenced by many break-out sheets within the workspace using external cell references. For something like "Site ID" in the main sheet, setting up a consistent workspace cell reference of…
-
Workflow to copy a row from one sheet and paste special, links to copied cells
Looking for a method to use automation or a workflow to copy a row from one sheet and paste special, links to copied cells to a row in another sheet. Any suggestions appreciated.
-
Requesting help reporting top three vendors for three locations based on a common review database
Our team is trying to build a tool to intake vendor reviews based on five averaged criteria to inform vendor selection on future projects. I've built the form, a review collection database, a review metrics helper sheet, a vendor masterlist and a preliminary report. I'd like to be able to consistently report the top three…
-
#UNPARSEABLE error in COUNTIF formula with OR function
Hello, I am unsure why this formula is returning #UNPARSEABLE. =COUNTIFS({Task List - Texas Projects FND Prepare}, @cell = Name@row, OR(({Task List - Texas Projects Agent Status}, @cell = "Red"), ({Task List - Texas Projects PM Status}, @cell = "Red"))) It is supposed to count the number of times a name in the "FND…
-
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?
