-
Checkbox not working
I just created a worksheet that has many checkbox columns, however, they appear as regular text. My older sheet still show the check box. Is this a system issue right now or something new?
-
What is the best way to handle changes on assigned person?
Suppose one of my coworkers left the company and there is this new person coming in to fill the same position, same responsibility, etc. I want to make sure all of the shared sheets (not just the owned ones) and also all of the assigned cells transferred from the person who left to the new person. What is the best way for…
-
Link and Access
How long does a link and database remain valid for our clients to access their data in Smartsheets?
-
Indenting Rows automatically
I have the following data in a sheet. I want to create a report (or anything that makes sense), that says if it is anything other than "Top Level", it will be tabbed over under the parent process it aligns to. Parent Process "1 - Process Details Test" aligns with Process Identifier 1. I am hoping to have this automated.…
-
Maximum Logic for Conditional Forms?
I have an intake form which asks something like: "Select the Offices that you have staff in" and has a multi select of all of our offices. Then if they chose X, Y and Z, The logic fields would say "How many staff do you have in X office" and "How many do you have in Y office. The problem is that the logic field for "select…
-
Add a summary table in calculation sheet to dashboard
Hi team, I have a simple summary table in my calculation sheet. The table is calculation from another data sheet so data will be updated. I want to add it to my dashboard. How can I do so? I only see add chart, link, no table.
-
Sharing reports with free users
Hi - I have created a report and shared it with an external free user, however, he is unable to see anything on the report. I also tried publishing the report and placing it as a widget in a dashboard with no luck. Is there anyone that has done this and can let me know how to provide them the info? I also wanted them to be…
-
Using automation on conditional formatting
Hello. I am wanting to set up an automation rule that will turn all of the information in these cells to 0 at 6AM each morning. I also do not want it to ruin the conditional formatting on each cell. The columns go all the way up to a count of 532. As you can see, 0=green, yellow=1, and 3>= red. As mentioned, I would like…
-
Automation works correctly when manually changed in sheet but not when input through form
Hello, I created an intake form for a project request. In the form there's a field where the submitter has to select from a dropdown list of Contract Information choices. Here are the automation logic I have: When I tested it by selecting the different options in the dropdown in the sheet column, this works correctly.…
-
Need help fixing formula (single value for multiple selections)
I was working on coming up with a formula that if the user selects either one choice or multiple choices in the same category it will equal the same or highest amount. The sample data I used was as follows: Dog, cat = 3 Mouse, rat = 2 Snake, lizard = 1 The following formula was suggested to me and it does work to a certain…