-
Creating Automated Emails are specific times
Hello! We've developed a form; our client would like to see it being sent to them daily at 1100am, and 0300am. Would this be possible? So far, I've gotten this far, but I believe this wouldn't work because Condition two contains "Where created today" submissions that are created at 0235 would not contain yesterday's data…
-
Decimals keep changing
I have a dropdown column that we used for style numbers. They might be numerical values or alpha/numeric values. The column has always show the value that was selected in the dropdown as it should until the last week or so decimals are being added. No matter how many times I remove the decimals from the column when new…
-
Can I use a form to edit information of a register?
Hello to all of you! I'm brand new using Smartsheet and I could use a hand. Hopefully I'm not crossposting. :) We have a sheet with various fields. Sometimes we have meetings and we take a look of the values of one row at a time. That is sometimes exhausting because we ae moving back and forward, left to right to see each…
-
Conditional formatting with formulas
Is it possible to conditionally format a cell where based on the answer to one cell the formatted cell changes its formula?
-
Resource Management Panel not showing all of the managed resources involve in the project
I manage to use the resource management panel, and also the specific sheet and resource management project also seem to sync. One issue though, I have quite a lot of people involved in this particular project. However, only 2 people seem to appear on the panel (as shown on the attached image). Can anyone help me with this?
-
How to include categories in horizontal axis while displaying independent colors for each series
I have a summary sheet with data I am using to include in a dashboard. My goal is to display this data as a bar chart where each cateogry is labeled in the horizontal axis and each category has its own color. I do not want to use a legend, the idea is the information can be quickly identified without cross referencing a…
-
How to calculate total time on Smartsheet
Hello, How can I calculate the total minutes on the smartsheet if I was able to obtain the start time and end time? I’m having some issues with the total minutes. As you can see in the last submission... if I do 1305-1245 it indicates 60 minutes. However, the real answer is 20 minutes. Please see the photo below: Many…
-
Can a recipient of an automated email request partially complete request?
We are in the process of updating hundreds of individual projects through the use of automated update requests. Even though we are breaking out the projects by dates, an update request to a specific person can require quite a bit of dedicated time. Can the recipient partially complete the "update request" without losing…
-
Add Legend to a Report within Dashboard (Widget)
Pulling a report that has colors (i.e.: risk bubbles, etc.) into a dashboard, does not look like there is a feature to add a legend, is this correct?
-
Issues with Form
Hello, I am having issues with my form: - When User fills out a form, they have to choose a department number from a dropdown. After the filled out form is uploaded into the sheet, the department number is changed? Example: User selects 577 in the form, but in the sheet it shows as 577.0 Here are some screenshots: The…