-
Aligning Columns in a Report that is pulling Data from Multiple Sheets
I have a Primary Column in two sheets with the same data - Project IDs. The subsequent columns are different, however. One sheet has team members info. The other sheet has budget info. Can I create a report that pulls from both sheets, and the Team Member info is side-by-side with the Budget information? As I understand…
-
Form multi-line text box issue
Hello, When someone fills the form with multiline text, they can put space and a new line however, the way you receive it is one combined text. Any workaround to fix this? e.g., in the form, you can type xxx yyy zzz the way you receive it is xxx yyy zzz Thanks,
-
Outsourcing Smartsheet
Hi all - our staff member who handled all Smartsheet content has left the organization. I only have time to learn some of what is needed for the 2023 dashboard and integration needs. I am looking for assistance quickly and am willing to outsource these two projects. Would anyone have referrals to share? Thanks!
-
Can multiple blueprints use the same intake sheet?
Hi, I have fast and slow projects. I want to use the same intake form for both projects, with a selection box to indicate the type of project. Can different blueprints use the same intake sheet and intake form, or are multiple intake forms required? Thank you 😊
-
Move a cell in the same sheet and make it a sub-task
Dear Community, My primary column is a Project Name. There is also a column called "Location." My objective is to add a new line (manually or through the form) to the sheet and then let Smartsheet sort it and put it together with the other lines with the same locations. I would also like to make it a sub-task to the first…
-
How do I remove the last 3 digits from the right-hand side of a column?
For ex: I have $4,478,999. I would like to convert it to $4.479,000 or say nearest 1000 value and then cut the last three digits at last to get $4,479 only. Any idea how I can get it?
-
Is there a way to tell what sheet a form is connected to?
I've been sent a form to potentially edit but the requestor does not know what sheet it is connected to. Is there a way to figure out what sheet a form is connected to if you do not already know? I'm asking around but got curious if there was a way to figure out just using Smartsheet. Thank you!
-
Best way to have a client facing dashboard act as a communication hub?
Hello All! We have a client facing dashboard (draft) setup, but we have not rolled it out yet. I have included a screen shot. We are in process of finalizing a more broad set of information. Pretty basic setup as of now. I would like this to be a client eco system, where they get all of their information and do all of…
-
Where does Smartsheet record the user name/ID of the form submitter?
Our team tried to get fancy by asking for the form-filler's User ID and try to get Smartsheet to perform an 'auto-lookup' of that ID in a separate spreadsheet (or maybe the user directory) to autofill their name, email address, department, etc. Naturally, that didn't work. So now we want to get back to basics. But, uh...…
-
Building contingency into project plans
What is the best way to manage tasks that have a high degree of uncertainty in the duration? An example might be resolving a design problem – sometimes they are quick, sometimes they take a while. A previous software we used, allowed you to put in a best case and worst-case estimate for each task – effectively adding…