-
Smartsheet Removing Zero
I have a course code 30657.201930 that I am pasting into a cell that is Text/Number. It drops the last zero, so it says 30657.20193, not 30657.201930. I tried adjusting the decimal points, but I cannot get the zero to stay. I'd like to keep the ability to paste the course code from another document, but I want to be sure…
-
Is there a way to update referenced sheets using vlookup and/or index and match?
Hi there, We have an issue where we provision a project from our intake sheet, but after it hits the project roll up sheet, we can't update the status. Here's a summary of how our workflow: Intake listing sheet - has our projects intake, which eventually end up as an "approved project". Each initiative has a unique ID…
-
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…
-
OFFSET function equivalent?
I realize there is currently no smartsheet function equivalent to the OFFSET function in Excel. (But it would be REALLY nice if there was one!) Until that particular enhancement request is finally achieved...I need help finding a workaround. My situation: I have a sheet of data where the columns contain individual employee…
-
Formula for at-risk flag, due within 3 days
Hi! I would like to have my at-risk flag turn red when 1) a due date is within 3 days or past the due date and 2) its not completed. I am using the below formula but it doesn't work: =IF(AND([End Date]3 < TODAY(-3), NOT(Status3 = "Complete")), 1, 0) I tried it with making it TODAY() and it works for overdue items, but I'd…
-
Calculation within IF statement
Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise…
-
Automatically Add recent changes information to a row.
Hello, I'm trying to look If there is an option to automatically update the changes happened in the worksheet from past 10 days in to new column (Lets assume the column name is "History_Past10Days") Information I'm looking in this column(History_Past10Days): All the column Names updated from past 10 days Ex: Sheet has 20…
-
Excluding duplicates from formula
Hi there! Had a wonderful talk with a Pro Support the other day, and he helped me write an incredible formula for counting "Left to Sell" value on sales items our team is selling. However, I noticed after the fact that it is counting each item as 1 sale, and there may be some sales that cover multiple items but should only…
-
Using Automation/Workflow to copy multiple languages form responses into one sheet
Hi, I have two forms one in English and one in Spanish. They provide exactly the same responses, just in their respective language. The Spanish version still has the field headers in English while the labels are in Spanish. I have created an automation that filters for a particular school and creates a copy of the row on a…
-
Remove name from Automated workflow I created
How do I remove my name from I automated workflow I created and add someone else name. See image attached?
