-
Is there a way to add a Dashboard to another Dashboard so it shows up visually like a report?
I was able to add a link to the dashboard but would love for it to show up as a visual instead of just a hyperlink. Thanks
-
DATEDIF for %Complete
Hi! I am wanting to write a formula to automate %Complete column. I have the start date / duration / end date. In excel I would write - =DATEDIF(A1, TODAY(), "D")/B2 - to find the difference between the start date and today's date and then divide by the duration. How do I do this in smartsheet? Thanks in advance!
-
Admin Control Vs Editor Can Share
Good afternoon, We have a workspace with ONE master sheet that it is crucial no one but the Admins are able to make changes to. We also have other sheets that feed that sheet with automated actions that require users to be able to delete rows and add rows etc However we just try to restrict those users to "Editor - Can…
-
How to redirect a user to a URL during Form entry, if they answer Yes to a certain question
I am looking to gather supplemental information as part of the Form entry process. When the user answers yes to a certain control-question, they need to answer 10 more questions. Although I could use conditional logic, to present the subsequent 10 questions, in this case and I do not want to clutter the main form, or main…
-
Automated - Request an Update
Hi - I have created a few Request an Update via Automation. I have tested them and they are working great. My question is I have a couple of sheets that may have many rows that will need updates (12 or so) and they come out in 1 email. I have other sheets that may only have 2 or 3 rows that will need updates and individual…
-
Form with auto calculation
I've created a form that will be sent to our affiliates asking them about budgetary needs. Is it possible to have totals calculated on the form prior to submitting it? Also, is there a way to automatically send a copy of the responses (without having to check a box)? Thank you!
-
check duplicate row and keep only the last one
Hi guys, Hi have a sheet with an automatic import (using Data Uploader) For some reasons, sometimes I have two times the same row datas collected from my data sources. How can I use a formula to check if I have duplicate row and if I have duplicate row, only "keep" (or check a box for the row) the last import (I already…
-
Date at Document Builder not show as setting
Dear All, when i use the document builder, the date set is DD-MM-YYYY, it shows me always MM-DD-YYYY, how i can change this issue? Thx in advance for any help.
-
Form - rating & access restriction
Hi - is there any other way how to assign points to each question/answer in the form instead of using helper column with formula to get "rating"? That would be really helpful if this could be done directly in the form creation/settings (similar to eg google form). Also, can we restrict the access to the form tocertain…
-
How to count crosses and starts
Hello, I have a production chart where with times of 6am,9am,2pm,5pm,9pm,2am,4am. At any given time, under those boxes at any given time we can have a box labeled Start or Cross. I have created another sheet to track starts and crosses but how do I get it to automatically pull from my chart to the tracker? To clarify, if I…
