-
How to make a secondary x-axis on column graph
Hi, I need to capture 2 catagories on the x-axis of the chart, one for cohort and one for month. Each cohort will have Jan - July months, there there will be 2 groups on the x-axis. For example, here is my sheet: and so far my graph looks like this: The months are correct but I need them grouped with a second axis for…
-
Auto Add a Date
Hi, I have a Smartsheet with a Check Box for all clients that started services as well a a date column for which date they started. I would like to create a formula where a a date Auto populates, but the date should be 30 days later then the original date of when services where started if the checkbox is checked. As of…
-
How to collect a form user's name anonymously?
Hi all. I want to send a survey form using Smartsheet to a group of users. I want to be able to collect the user's name on the backend (if possible) without the user knowing I'm collecting their name. It's basically so the user will be truthful in their survey responses AND only I would know who said what. Is there a way…
-
How Can I use a form to update empty cells on an existing row?
I have a sheet that will have data that changes, in this case locker assignments. I want to create a form for people to assign themselves to an empty locker, by providing them with a dropdown list of available lockers, and include if they're top or bottom lockers through logic. I don't want the people to have access…
-
How to count elements on a structure
I have a “Request” sheet that references a bill of material (BOM) structure, similar to the table below I am trying to determine that if in my “Request” sheet I get a request for Part C, then I should be able to count from my BOM sheet that I only need 3 units of Part E, but if I have an order for Part B, then I would need…
-
Task Scheduling
I am testing Smarsheet. I am satisfied with the task dependency support but noticed one thing I am not liking and that is - if I, for example, enter 4 tasks and add the dependencies causing the dates to adjust accordingly -- then remove a dependency on a task that got pushed out, it will not auto schedule itself back to…
-
Formatting Smartsheet
My company uses Smartsheet, which I like using. However, I would like to format the sheet similar to how I was able to set it up in a competitor's software product. Is this possible? My Finance Department wants me to set up my Smartsheet to show the progress of multiple candidates as they complete tasks and track the…
-
Updating the non-working days under project setting in a column
Is it possible to list the non-working days under the project settings in "duration" column in one workspace and automatically update that information to all other sheets and workspaces? Or do we have to update the non-working days in each sheet or workspace separately.
-
Sending Rows Monthly to Individuals w/o Underlying Sheet Access
Hey y'all - I'm looking to set up a sustainable option, probably a workflow, to send row items to an individual for all entries they submitted in the past 30 days, without giving underlying access to the sheet. The specific use case here is this is a team wide hour reporting sheet, and we want to give folks visibility into…
-
Work FLow not working
Is anyone having issues with workflows not functioning properly? My workflow is supposed to be routed to one person but instead, it is routing to everyone. I have called support, had zoom meetings and the only determination is my workflow is correct. Has anyone else had issues with workflow routing and if so how did you…
