-
FORMULAS
I have a smart sheet for job progress I have indicdual lines of % of jobs what formula do I use at the top to get the overall % of all jobs.
-
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!
-
Display jobs for the week and who worked on it?
I want to create a sheet that can show the jobs for each week and who worked on it (multiple people can work on it, due to different departments).
-
Approving Changes Made to A Shared Sheet
Hi all, long-time listener, first-time caller. I have been tasked with discovering a way that a sheet owner can control updates being made to a shared sheet through some form of 'approval' feature or process. My scenario is this: there is a master sheet displaying all approved, company-wide projects, complete with columns…
-
Scroll wheel not working with system settings
I swear I posted this somewhere else, but cannot find it now. Opening a new post. I am able to scroll, but I find that Smartsheet does not respect the settings of the mouse scroll wheel while I am in a sheet or report. If I go to the home tab, or scroll around in my favorites, I can see that one click of the wheel ~= the…
-
Removing Answer Choices from Webform
I am making webform for event sponsorships. I would like the sponsors to select which events they want to sponsor - but each event can only have one sponsor. Is there a way to have a dropdown menu that eliminates choices once someone else has selected them? For instance, if I have sponsor event A, event b and event c, then…
-
"Move to Another Sheet" Changed?
Has the "move to another sheet" functionality changed? In the past, it has always copied the rows to the chosen sheet and deleted them from the source sheet. I have tried it three times this morning and managed to copy them three times to the designated sheet and they still remain in the source sheet. And yes, I am sure I…
-
Formula for a carriage return within a cell
Hello i have this formula for milestones, however I would like to format it so that the "Milestone Count, Milestone Reached, Milestones to Go are all lined up to the left of the cell. I cannot change the size of the cell as there are multiple tasks in that same column. ="Milestone Count. . . . . . . " + COUNT([Notify…
-
Pasting into an Auto-number does not auto-number in sequence
Hi all, I just pasted a list of about 20 records into a autonumbered sheet, The auto numbers did not appear in sequence. The paste is as per the original sequence, the autonumber field, jumps around with out rhyme or reason? e.g the fields sequence 179, 180, 181, 184, 185, 189, 190, 191, 192, 194, 195, 197, 200, 188, 193,…
-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
