-
Formula Malfunction!
Has anyone every had a situation where a formula in a cell calculates improperly if it references a cell whose value is also derived based on a formula? I have a formula set up where it's looking at cells in the current and previous rows to calculate total hours worked in a day. (I borrowed this formula from one of you…
-
Critical Path View for Viewers
Is there a way to allow people with viewer access to a sheet to see the critical path on the gantt view? The project team would like to be able to view the critical path but not allow every person to have edit rights on the sheet. Any advice is appreciated!
-
Return name of column
Hi, I have a smartsheet with colume names that are acutal dates of a calendar. I am looking for a solutnion to query the name of a specfic column if it has a certain single digit value. (So I get the date back). Any ideals?
-
How to automatically show a symbol
I have a status column which is a picklist field. The basic values of this picklist are pass / fail / on hold / retest. How can I manipulate the values that I can use in the symbol field?
-
Formula for basis of reminder generation
Hello, Here is my scenario: I have two directors who need to be notified upon the completion of a form based on their customer. It seems that the easiest way to do so is to utilize the reminders based off the date generated once the checkbox is marked complete. Right now I have columns with the contact list for the two…
-
Rounding up the results of an IF formula
I finally figured out how to create an IF formula to get an AVG of Children divide that by a specific number, and enter "N/A" if there was nothing in the children cells. NOW my boss would like to Round the resulting number up to the next dollar value. Sometimes, I think she just likes to test me! LOL Here is the formula I…
-
Recurring dates on a calendar
I am converting some calendars from Sharepoint into Smartsheet, and can't figure out if or how I can make events recurring. For example, I'm building an on-call schedule and the schedules are regular. Every so many weeks, each person takes a turn. Has anyone been able to accomplish this? I don't want to have to enter each…
-
Enhancement Request: Please fix SEARCH
I really don't like the search feature implementation. I get too many false positives and the wildcard usage is just plain annoying. So, here's a few things that might make me less annoyed. 1. In the Type section, let me search Column names. We can already search Sheet and Sight names. I've written the code in Python, so…
-
Mandatory Cells
I've done a formula to add "date required" when the box is checked and " " (blank) when date is not checked. Issue is when the user puts the date in the field, it removes the formula, so if they unchecked the check box, or remove the date, the date remains blank. Although I have formatted the cell to stay Red if blank, I'm…
-
Aging Items Based on TODAY
Hi, I'm trying to use the TODAY function to work out the age of an item. In Excel I would have a cell with =TODAY(), and do a calculation to subtract the date of the item from this. I have tried using =TODAY(), =TODAY, TODAY, TODAY(), but can't get it to bring back today's date (got #INVALID COLUMN VALUE, #UNPARSEABLE or…
