-
Why can't I see zeroes?
I've got a long formula that determines an IP address for a computer. That formula should result in a formula for an IP address that looks like this: 10.20.12.32 However, when there's a zero entry, SmartSheet is omitting the zero, so the result looks like this: 10..12.32 I need to show the zero! If I type a zero in a…
-
time based reports?
I'm sure what I'm looking to do is not that difficult, I just can't find a way to achieve it. What I have is a sheet that consists of quote amounts ($) that are relative to a quote date. What I want to do is to look at how many dollars we have quoted that are on quotes a month old, 2 months old, etc. Ideally this would be…
-
how do i create a task with multiple durations/start/stop/start/stop structure?
Hello I have a task made up of multiple intervals, can smartsheet include these in the tasks/gannt? Example - task 'a' - start 28/4, finish 29/4, start (1) 2/5, finish (1) 4/5, start (2) 6/5, finish (2) 13/5 Thanks Alan Russell
-
Different drop down lists in each row?
i'm 2 hours into this experiment so please pardon my ignorance. I'd like to create distinct dropdown lists for different rows in a worksheet. So the column header is "Color" and the first row is for "Paper" and I have 20 colors to choose from. The second row is for "Crayon" and I've got 100 completely different colors to…
-
Please advise on best way to set up a SS
-
Feature Request: Switch, Vlookup, and/or Lookup Functions
Please add one or more of the following functions: switch, vlookup, and/or lookup. Note that this would make it easier to reference rate categories in a rate table without having to use a huge nested if function.
-
Kudos: New look
I like the new look to the Support Center. https://community.smartsheet.com/support Easier to navigate. Well done. Craig
-
Data shuffled after I save
Hello all, I have a sheet shared with 7 people. Almost everytime I save there are multiple rows that are randomly shuffled into different spots on the sheet. I have no formulas or macros... I thought I would throw this out to the community, any ideas?
-
How to link a column to another sheet so I can run a formula on duplicate values?
Is there a way to link a whole column to another sheet? I need a whole column linked, not just cells. Copy and pasting 500 cells at a time is not going to work, as it will not update if rows are added or deleted. I considered a report, however that would only accomplish part of the job, as I want to filter the results. I…
-
Check Box Column Property Not Working
I feel silly asking such a basic question, but it's got me stumped. Normally, under Column Properties, when I select Check Box, a box appears in the column as it should. However, no matter how many times I've tried, no boxes appear. It seems to remain as a Text/Number. Has anyone run into this? Thanks!