-
Limiting Information on Child
Hi, My parent sheet has an automation with certain conditions (If department "A", and Type of Request is "A") to copy cells to another sheet for individuals that only need limited info. This works, and is great, but I want to limit the information even more (no attachments, no reasoning column). How can I accomplish this?
-
Copy value from one cell of the same row to another
Hello, SmartSheet community. Does anyone know if there's a way to automate for new row created/existing row updated event to grab the values from one column and paste it into another column of the same row? Both columns are pull-downs. Source column has a pre-defined list of users where one or more user can be selected. I…
-
Automation to modify cell value, cross referenced
I have one sheet that is a full list of all the serial numbers of items we have in stock. There is a separate sheet that tracks all the serial numbers being deployed. Can I cross reference the deployed sheet and have a cell modified when a serial number on the inventory shows up on the deployed list? Find serial number on…
-
Sum against matching criteria onto another sheet
Hi! I'm trying to create my calculation sheet in order to develop my dashboard, but I can't get my SUMIF to work. This is a project tracker in that I was able to get my project-type counts to work with the COUNTIF formula, and now I want to do the same but on the total $ amount column, however I cannot get this to work!…
-
Seeking automation to auto-update Timeline field (today, tmrw, next week) based on current date
I am seeking to have a smartsheet field for Timeline (Today, Tomorrow, This Week, Next Week, This Month, Next Month) to auto-populate based on the current date. I'm making mistakes remembering to shift timelines week-over-week to the appropriate option and it's then throwing off my timelines. Thanks!
-
When Approvals are Declined/Rejected
I have an approval workflow that includes three people: Program Manager Finance Representative Payee The Approval Status column for each is locked and updated automatically via the request approval workflow. I am trying to figure out the best way to handle if any of them click "Reject" rather than "Approve". First, the…
-
Looking for an expert
I'm trying to hire an expert to help me set up my sheets, dashboards and reports as best as possible. I need to hit the ground running with this project. Any ideas?
-
Can files kept in File Library be "Published" to anyone with the link?
I have an automation email setup to request ad materials from customers via an update request and need to include our ad specs. Instead of attaching the ad specs to every single row on my sheet (one at a time), I can add a hyperlink to the email body and wanted to link it to the document/pdf kept in File Library, shared…
-
Smartsheet's JIRA Integration: When is the tool going to be compatible with JIRA's V10 Upgrade?
We recently moved to Jira v10 due to potential security risks within JIRA and found that the Smartsheet Jira Connector isn’t compatible yet. Given that this connector is a premium add-on, I’d really expect it to stay aligned with major updates like this. Jira v10 was released back in August 2024, and the lack of support…
-
Need to remove timestamp from date field
Hi community, I am trying to remove the timestamp from a date field that feeds from a data shuttle. I have tried to use the DATEONLY formula, but I am getting an error message of: INVALID DATA TYPE. Within the new column I'm trying to build, I tried both the column type of both date and text/number, but I still can't get…
