-
Adding comments in a specific cell
I have seen this question in other threads, but no actual response other than referencing the cell in the row or column comments. Direct question: Can you currently add comments into a specific cell? If no, is Smartsheet looking at adding this feature? Thanks for your help
-
Integrating Gaant View Items and Calendar View
I'm having an issue finding a solution for meshing Gaant charts on individual sheets and multi-sheet calendars. On individual sheets we have "Phase" dates, these are anywhere from a few days to a few months. These are great for the Gaant view. The group calendar shows all the items from the individual sheets, including…
-
Can you have 1 form with multiple sheets driven by logic/selections on the form?
I think I know the answer but wanted to ask the community. I am wondering if you can have 1 form with logic that says - if you select "this drop drown item" you will get a set of questions and the data will go onto sheet 1, if you select "another drop down items" you will get different questions and the data will go on…
-
restrict a form to only the person submitting
I built a form for contractors to enter the days worked, hours, tips, etc.., and the sheet calculates total pay, total hours, etc. Is there a way I can make the form so that when a contractor opens the form, they are only allowed to submit their info? Currently the name field is a dropdown listing all contractors, and…
-
One task the crosses multiple projects
Hi all, I have 10 sub-projects that are part of one main project, so have them all listed on the same smartsheet. They are for the set up of multiple new sites, and each need to be monitored individually as each have their own individual tasks. There are however a few tasks that run across all sites, like procurement for…
-
Children Status Nested in IF statement with Checkboxes
Hello, I feel like this is a simple problem but for some reason I keep getting "#INVALID OPERATION". I would like to have the formula look at the children rows and if any box is checked then check the parent row box, otherwise leave it unchecked. I came up with : =IF(CHILDREN() = 1, 1, 0). That gave me #UNPARSEABLE. So…
-
Disable auto save
Hi, I need to disable auto save in Smartsheet. Help?
-
Formula Character Limits
Hi, I have an index/match formula searching 36 different sheets for a single input. As you an imagine, this is a very long formula and I think I may have reached the limit for a single cell formula as I cannot continue to add to it. Is there a way around this? What i'm doing is creating a master sheet in which one formula…
-
Impossible to open the dashboard files in the smartsheet
-
Alert someone not sending notifications
Hi I have a very standard approval workflow set up, that is not issuing alerts as expected: The initial Approval request is sent through (the emails and Smartsheet alerts for that are correctly received) and the approval or rejection action is done, but the alert to be sent for "If Approved" or "If Declined", just never…
