-
Use a formula for subtraction between two columns
Hello, Unable to find the answer to assist with my formula query, i would like to simply calculate 'Contract value' & subtract 'Current spend' to get 'Remaining value'. I've tried multiple options and keep getting errors, so appreciate any assistance as i believe it should be quite easy....
-
Help with Supply Inventory & Checkout Tracker
I made an inventory tracker to keep track of our supplies, and on a separate sheet I made a tracker for requests to check-out supplies and a form for this. I want people to be able to select multiple items on the form. The issue I am running into is that I had created a formula to pull the number we have “In Stock” from…
-
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)) +…
-
Automation using reference cell
Hello everyone, I hope you're doing well. I'm facing a difficulty in setting up automation. In the project model we've adopted, one person is responsible for monitoring the project progress, and this monitoring is measured as the stages are marked as Complete. This calculation is straightforward with a formula that…
-
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.