Hi, I've done my research and it looks like people have had to use Zapier for this specific use, but want to throw it out there again before i go that route! I am looking to pull back a value from a r…
In Card View, my Subtask checkboxes do not tally at the bottom of the card (Full View, closed card). This is a new development. Any thoughts to help? Thanks!
Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). Thi…
Is there a way to create a cell reference based upon a horizontal axis? For example, for a given column, I want it to always represent the cell directly to its left. For this example scenario, a new c…
Hi, I have a formula set up to basically check if an action is open. Currently the formula is as follows: =IF(OR([Post AFC Change Status]7 = "1. Received", [Post AFC Change Status]7 = "7. Withdrawn", …
I'm attempting to track the number of requests received and the months they were requested. What formula can return a Month name for a date (xx/xx/xx) e.g if I have 12/25/19 the formula will return De…
Hello, I am developing an inventory reorder system and I need the status of the line item to show "Reordered" when the check box is checked under "Order Status" I recognize that there are multiple tru…
I have a formula that shows the Status of a milestone and it currently reads the due date (Finish) and automatically updates to off track if the due date has passed and the status if not in at risk or…
Hello, The Today function is not working when included in a simple IF statement. It was actually working a while ago but now it is not working. I tested it out by simply trying =IF(Cell@232="2",=Today…
Hello - I need to find a way to have a Date field default to the current date on a Form. (I can't use the systen-date field, as user needs to be able to override 'todays Date' if necessary) Unfortunat…