-
Turning a Paper Report into Smartsheets
Greetings, While I appreciate consultants, I'm not currently seeking to hire anyone to do this for me, I just have general questions to accomplish my goals. My direct supervisor sends out a request for certain data to various people on his staff once a month. It's a "Service Report" of sorts that is used to provide data toā¦
-
Parent Row Formula Based on Children's Status
How do I use a formula in my parent row to update based on the children's status? I want the parent row to to "Active" if any of the children are "Active", "Complete" if all of the children are "Complete, otherwise, "Inactive.Ā
-
System Generated Time Stamp Issue
I have a project that needs to count how many lines are added on a particularĀ day. I found that dates convert to the next day after 7:00 pm.Ā I'veĀ tried (=dateonly) and the date still advances after 7:00 pm. I need to be able to capture based on theĀ true date. Does anyone have an insight into a solution? Thank you
-
Alerts & Reminders
Can we add to "specific date" and include recurring with a certain frequency with alerts and reminders? I'd love to set a reminder to the group to update a field on the 10th of every month, but I don't see a way to do this.
-
Alert rule has become invalid
Hi, I get an email that An Alert or Action rule has become invalid. What I am trying to do is use the Modified (date) field to send an approval request to someone if anything in the row changes. I think what is happening is that the Approval request is then recording "Approved" in the system generated "Approver Approval"ā¦
-
Saving spreadsheets in workspace
Hi all, I could not find any thread with this specific problem, pardon me if there is one.... I created a new Workspace, and within that workspace i also created a single spreadsheet. So i start writting content on that spreadsheet, then click the small "floppy" on the top left, close the page and then, when i come back,ā¦
-
Date calculation
I am trying to use an Excel date-related calculation in Smartsheet and I'm having trouble translating it into Smartsheet. Any thoughts on the situation below? Column A (Deadline)Ā is manual entry of Deadline date - no issue there. Column BĀ (Due in Next 60 Days) is supposed to return "TRUE" if the Deadline date in the row inā¦
-
Dashboard Chart Formatting
I currently have a chart on a dashboard displaying information from a certain range of data. If I change what data is being selected, it reverts to default formatting (e.g if I select different data for a stacked bar chart, it reverts to a non-stacked column chart and all the colors per series return to default colors asā¦
-
Security on Column Level and per User
Hi, Could we have a validation or anything that prevents some columns to be updated by a specific user? Not all sheet, just some columns. Thank you.
-
Create a Form with dynamic fields
Hi, There is a way where we can create a form and in this form we can duplicate a set of field as much as we need? Currently, I am calling a form and at the submission, I am redirecting to another form, and on submission, I am redirecting toĀ the same report. Could we have this in 1 form only? Thank you.
