-
Limit entry of % complete column
Is it possible to limit the entry of a % complete column to make my sheet more 'foolproof'? So only allow entries between 0 & 100 %? E.g. I use a conditional formatting rule that when a % complete is 100% that a row is 'grayed out', but if someone accidentally add 110% then no conditional formatting is applied.
-
Help with IF/AND formula
Hi--I've been reviewing sample Smartsheet formulas from discussions past, but can't quite get my (relatively simple) formula to work. I'm trying to return a checkbox for a given row (let's say 1) if "Rehab?" column is "Yes" AND "Xtra Cost (cog, rehab, tx, etc.) is blank. I've tried several different formulas, but most…
-
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…
-
Mixing overwrite with formula
Hi-- so, I have a wonderful formula in a cell whereby depending on the dropdown choice selected in another cell, X, Z, Y occurs in the cell where the formula resides. What concerns me is that sometimes a situation may occur where overwriting that formula is temporarily necessary. But we don't want to lose the formula there…
-
Suggested feature: Starred Sheets for easy reference
Problem: with a lot of sheets, it can sometimes be daunting to quickly find the on you're looking for. Proposed solution: what if SS used something like Google's "star" feature? Here's a quick mock-up just to get the juices flowing (potentially).
-
working days
heres the thin. in general we set projects as five working days, sure we all work weekends but in terms of setting teh critical path five working days works best. problem comes when we get to teh latter stages of a project and goods are being managed through the supply chain which is a 7day a week process ie goods…
-
Program Report
Hi There, Im trying to create a report on tasks that are programmeed to be undertaken in a specified date range (but not necccesarily starting or finising in that same date range). For example: I have a task that starts on the 1st of February and ends on the 20th February (i.e 21 days of work to complete the task) I want…
-
Can you only indent to 1 level or is there a way to allow further indents?
Can you only indent to 1 level or is there a way to allow further indents?
-
Update Request: How to set permissions on cells?
Currently, when sending update requests to partners, the respondent can see AND edit all selected cells in the row. Is there a way - or a plan for such functionality - to allow respondents to the update request to see certain cells, but only edit specific cells (maybe this would be an additional checkbox or the next step -…
-
Selecting the Next Task
This is a bit of a weird question but I'm trying to figure out how to make SmartSheet inform me what my next milestone is for a project. Basically I have a series of projects (say 40 or so) that each have their own project schedules. In those schedules, some tasks are marked with a checkbox to indicate they are critical…
