- How to connect symbols with text
Hi, I'm trying to connect the symbols to a column for "not started", "In progress", "Complete". Is there any way I can do it? I'm trying to change the text automatically when an assigned person change the status of the project. Please see the attached screenshot.
- Can we set cell linking based on conditions
I looked into a few formulas to do this such as if statements however I need to use cell linking because the value can be managed on both sheets. So if it changed on sheet A I also need that to update on sheet B (I have both an inbound and outbound link in the cell so it will work bi-directionally). But with cell linking…
- Today function issue
Hello Everyone, I want to address one issue that I am facing for a long time. I am using today's function in my sheet to check today's date for like birthdays or anniversaries and set the automation for 10 AM (Time zone in India (GMT+5:30). For Example - Assume on 23t December it was my birthday so at 10 AM I should…
- Alerts Not Sending Even if Adding an Attachment is the Trigger
I'm trying to create an alert so that when someone attaches a file to a row, the attachment and row information gets sent to someone else, but I can't seem to get it to work. Here's the workflow set-up: I DO get an alert if a new row is added with an attachment, but I need an alert for a row that already exists. I DO get…
- Automation and system column
Hello, We would like to get an email notification with the name of the last person who edited a row in smartsheet. To do this, we have set up the column “Automatic / system numbering” - “Modified by”. However, we have many automations in our grid. So a modification has an impact on different cells. And when the…
- In the automation email notification, is there a way to edit who the email came from?
For example, is there a way to edit the name Bill Sjolinder so it's from a different name or general name? Bill Sjolinder had created this smartsheet form and shared it to me. He transferred me ownership and still an admin.
- help with formula's
hello new to smartsheets. i am looking to make a V lookup that will crosslookup on 2 sheet to tell me if it is on that sheet or not. this is what i come up with so far. =IFERROR(IF(ISBLANK($[Cable Name]@row), VLOOKUP($[Cable Name]@row, {K2 Power/Motor Cable List Tracker Range 1}, 1, false)) Motor, 0) I would like it to say…
- how to check a checkbox automatically when all predecessor are met and change date to today date
Hi! I am creating a project where there a lot of tasks and predecessors. I created a box check column and would like to put a formula where when a row have all their predecessors statue to complete, the box check is checked. And in that same row, the date in one of the cell change to today date. How should I go about to…
- Workflow Automation Separate Conditions w/ alerts
嗨,我想figure out how to create one workflow where based on the dropdown value selected, it would send the appropriate alert. Example Stakeholder decision (Options - Approved, Denied, Deferred) If you select one of the three options within the dropdown, it was alert users with the appropriate email…
- Update the cell value by 1 on the 1st of every month
Hi, I want to update the cell value by 1 on the 1st of every month. Suppose the current value of my Earned Leave Column is 10, on the 1st of every month I want to increment it by 1.
