-
Image-Hyperlink
Wondering if there is a way to make an image as a hyperlink (Click on image). I have tested the option of adding image in cell, and also just add hyperlink with text, but I do not see way to actual make the image as a hyperlink. Thanks for any input.
-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
-
Link data into a cell out of an attachment
Hi, Is it possible to get a cell auto populated from data in an attachment in the form of a PDF or Excel? Our goal is to reduce manual capturing of data that continually changes. Y
-
Error When Saving Smartsheet
I have been searching the existing posts for something like my current experience, to no avail. This morning, I have been having trouble with my program management sheet. All of our current projects roll up to this sheet, and this sheet goes to my VP. It is large, but has always been large. I haven't changed anything…
-
Timesheets
My firm uses Smartsheet for timesheets and client billing. There are now 22 people filling in individual timesheets. There is a Client Name column with a dropdown box with all the client names, probably about 100 now. Monthly, I manually go into all 22 timesheets and update that dropdown box with new client names. This…
-
Schedule Cell Linking w/Lag
I have linked multiple project schedules together, but I'm wondering if there is a way to add lag time between the links? Currently the finish concrete completion date of the first becomes the clearing and grubbing start of the second, but I'm wanting to add a one week lag time between the two while keeping them linked.…
-
Automatically linking cells/sheets
I want to create a sheet that will automatically add any task that has been assigned to me in other sheets. Is it possible to set this up so it will happen automatically? I would like to avoid having to manually add every new task I am assigned from every project I am working on. Ideally I would like to set this up for my…
-
Master Project Sheet vs Master Project Report
We are looking at implementing either a very large (roughly 160 columns) master project sheet or a master project report. If we go with the master project sheet, teams would work off reports to update their respective data. If we go with the master report, I would aggregate specific data from each team sheet. The end goal…
-
Alerts & Notifications
Hello all, I'm trying to build a sheet that notifies the right person when certain new records are entered (e.g. alert Person X when a new record is entered that has a certain column equal to ABC). In reading through some of the posts, I understand that "conditional alerts" aren't developed yet so I'm looking for other…
-
If I lock a column, will that column move when a row is moved to another sheet?
I was going to create a column and lock it/and hide it - this column will hold all of my formulas. When a row is moved to another sheet, will my locked column stay put? I need to hide my formulas somewhere on my main sheet but a lot of moving is done by others and I don't want it lost. Thanks!
