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
Task subtask
I have a long list of people which I have created suntask for to indicate what projects they are involved in. Now I want to see a list of projects and which people are assigned to them. There does seem to be a way to get this info using smartsheets. I hope I am wrong.
Can I limit picture size by limiting max amount of pixels
Can I limit picture size by limiting max amount of pixels. Now the limit is 1000. Can i change it? thanks
Current date against a ticked checkbox.
Hi, I'm trying to come up with a formula that will populate a given cell with the current date if and when a certain checkbox has been ticked. Please note, this date must be fixed, i. e. it must NOT change as the days go by. Is this possible at all? I know this is completely wrong, but just to illustrate better what I mean…
Why can i CTRL+V to paste , but right click menu paste is grey=disabled
Hi, I'm trying to paste from word into a sheet. I can do it with a short cut, but right click paste option in the menu is grey out? I would like to paste without shortcuts, is it possible? Can i drag a web browser adress into smart sheet as a link ? thanks
I want to set the name of a field to be the column name it is in. Is that possiblle?
I want to set the name of a field to be the column name it is in. Is that possiblle?
Separating weekdays from weekends
Hi everyone, this is probably something very simple, but I still struggle, hope you can help. I have a large timesheet with one raw per day, every day of the year. The contractors will get paid higher rates on weekends, compared to work days. Initially I thought of putting an extra checkbox "weekend" column next to the…
SUM of linked values
Hello, How do i create a SUM of linked values from other sheets? If i break the links and add a numeric value the SUM-formula works. Best regards
Auto-fill formulas and corrupt references
Hello, I'm currently in the process of setting up a rather formula-heavy project sheet, linking project names, project numbers and multiple assignees to all the different tasks within the project. In order to circumvent the limitation of one assignee per task on my sheets, I've created additional (non-Contact list) columns…
COUNTIFS
I need to count the number of times the "Status" column = "Assigned to SCJ" and the number of times a date appears in "NDA Signed" column in the same row. Both criteria need to be met. The "Status column is a drop down list. The "NDA Signed" column is a date. In the parent row, I added this calculation but it is not…
Card view - parent title deeper level hierarchy
Hi, Is it possible to have deeper level of hierarchy in card view in regards to -PARENT TITLE. It would make it easier to know where the task comes from without switching back to grid view. Thanks
