Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Critical Path During a Project
I can't seem to get my Smartsheet to re-calculate critical path after a critical path item is complete. The critical path should change as items are compeleted. What tells Snartsheet to no longer look at a completed item so it can re-calculate the new critical path during a project?
Nesting Formulas
I need some help with nesting formulas for the following screenshot: What I'm trying to accomplish is an automatic change in the "Status" Column based on the following criterias: 1) If "%Complete" >= 1% and "%Complete" <= 99% and "At Risk" = 0 then "Status" = In Progress 2) If "%Complete" >= 1% and "%Complete" <= 99% and…
Limit Data Entry to Dropdown list
I want to restrict data entry to only the selections of the dropdown list. Is that possible in Smartsheet?
Designating Focal Date in Calendar View
Does anyone know if it's possible to have the calendar automtically use a date prior to today's date as the focus when displaying the 1 month, 3 week, 2 week, etc., display? By default, it displays the current week at the top of the calendar whenever the calendar is opened. Also, whenever I refresh the browser, the…
Change Management Solution
Does anyone use Smartsheet for Change Management scheduling? We are in the process of creating a change management committee and are currently housing our Change requests in Lotus Notes Database.... Which is less than desirable. Trying to see how we could use Smartsheet to accomplish this... Anyone currently doing this or…
Excel formula =SQRT()
I am looking for a similar foruma to =SQRT() in Excel. Does Smartheet have this feature/function in its formula list?
Linked Cells do not update colored format
If I have a Cell in Sheet A that is linked to a cell in Sheet B, it appears that the color formating of Sheet B does not get updated into Sheet A. i.e. Sheet B Cell = "Final" checkbox that is green (when Checked). Sheet A Cell = Linked to "Final" Checkbox where green colored formating does not update into Sheet A. I tried…
User identification
Smartsheet form is embedded into our web page, where we have our users registered. How can we include their user id into Hidden field. Regards
moving rows upon completion of task
We want to move completed tasks within a given hierarchy to the bottom of the list allowing active tasks to "move up" Ideas?
Conditional OR command
Is there a Conditional OR command anywhere. I see an "AND" but no "OR". So strange that I cant find OR since its part of any regular expressions and saves time.
