-
formula to pull in sheet link from another sheet
Currently when I write a formula to pull data from another sheet, all works fine. But I want to pull the Sheet link from another sheet, it only brings in the text for that cell with the hyperlink link and not the hyperlink as it is in the other sheet. I have been doing each cell individually to hyperlink another sheet, but…
-
Subject: Issue with Dynamic Remaining Time Calculation in Reports Not Updating Automatically Body:
Hi, I hope this message finds you well. I am reaching out to seek assistance with a challenge I am facing in one of my Smartsheet projects, specifically within a sheet titled "Projects Info" and its connected report. Problem Description: In the "Projects Info" sheet, I have implemented a column formula to calculate the…
-
Separating Table by Week
Hello, I am working on a project where I am pulling in employee utilization totals from sheets being populated by data shuttle on a bi-weekly basis to a table that calculates totals. The cloumns are basically using SUMIFs to populate the totals but I'm running into an issue where I can't separate these totals by week. I…
-
hours into days and hours
Hi All, How do i change the Duration to days and hours instead of just hours? Below are the formulas im using Thanks in advance! =INT(Sum@row) + " hour(s) " + IF((Sum@row - INT(Sum@row)) * 60 < 10, "0") + (Sum@row - INT(Sum@row)) * 60 + " minutes" =((VALUE(LEFT([End Time]@row, FIND(":", [End Time]@row) - 1)) +…
-
Multiplication and addition in one calculation error
Hi , I want to add a percentage to one cost then add additional costs without the percentage. Have tried various setups with Unparseable every time. What am I getting wrong?! =([valueA]@row *1.18, [valueB]@row, [valueC]@row) =([valueA]@row *1.18), [valueB]@row, [valueC]@row =(([valueA *1.18), [valueB]@row, [valueC]@row)…
-
Status Column Change to Record Date of Change
Hello, I am developing metrics for a group at my company and need some help. They do not log when they mark something as complete by date just by status. The date of the status change is in the cell history but I was wondering if there was a way to write a formula to show when a status is set to completed it records the…
-
Automated Reminder - Can we hide the sheet weblink
Hi team, is it possible to hide or remove this sheet link from this Automated Reminder. The idea is to just sent the audience a reminder not the link to the SS wherein this is all setup.
-
Index/Match, Distinct/Collect formula question
Hi folks! I'm trying to create a list of unique values from a cross-sheet column based on a single criteria. This is a tool for users, and I want them to be able to provide the input for what the value of that single criteria is. What I have that works is: =INDEX(DISTINCT(COLLECT({Application Estimates by PID: MOTS ID},…
-
Help counting items in a column in another sheet if between defined date ranges
Collecting the count of an item column in another sheet if the date range is between two dates. I am using this formula and it works well, but a bit labor when I have 48 that have different source and date ranges. Plus thinking of 2025, it will be a pain to redo them when the next year rolls around vs just changing the…
-
Formula Question
I'm not sure if this is an option but I am trying to create a sheet that is going to track staff visiting sites. This will need to be on a rotation. Example: Sally visits one site and the next time that site visit comes up the next staff member would be scheduled to visit. The goal would be to have the staff equally visits…