-
IF Formula, Can it consider multiple columns?
Good Day, I am trying to find the best way of indicating the data within 3 columns. I thought the IF formula would do the trick. Currently I have 2 columns Unit Seal Broken (Yes/No) and then Reinventory completion. I want the formula to reflect in the Status column. see attached. Basically what we need it to do is If the…
-
Subtract 1 time column from another at the row level using the time function return in same format
I am subtracting one time column from another. I was able to get an answer, that appears mathematically correct. However I would like the answer to return in the hour : minute : second format as it started in. Is this possible? I am subtracting Start time from End time to get Run Time and used the formula below:…
-
Is there a way to customize the layout of the approval email
Hi, I have an automation set up that sends the data to an approver who either approves or declines. They can comment but was wondering if 1- we can put comments at the top of the email and the fields below 2-can we remove the access to the sheet but still give them view on all the fields? 3- Can we add text boxes or…
-
Dynamic View "the number NaN cannot be converted to a BigInt because it is not an interger"
I share multiple Dynamic Views with 3rd parties via Safe Sharing. Last week, one reported that they could not login and were getting this error: "the number NaN cannot be converted to a BigInt because it is not an interger" (screenshots attached). They tried using different browsers, clearing cache's, etc. with no solve…
-
How to use IF
This might be simple, but I am a beginner. Team members will be pasting one of these 10 cities/counties into the Area column and selecting either “Experimental” or “Written” in the LOB column. I want their choices to automatically populate words into the District Column. Some have a 1 to 1 relationship, others have a 1 to…
-
Python SDK update_column syntax
Using the python SDK I am attempting to update the options list in a "Pick List" column type but can't seem to get the syntax correct. I keep getting the error 1008 Unable to parse request. My code is: ss.Sheets.update_column(4065220*********, 5852349******, {"type": "PICKLIST", "options": ["a", "b", "c", "d", "e"]} error…
-
Need for Unique identifier column in Data Shuttle
Hi team, I have a sheet in Smartsheet which captures data via form and also know wanted to update with data from excel. For this I have created upload workflow and have attached one drive excel attachment. I do not really have ID column within my sheet, because the participants who are completing the form do not know this…
-
Is there a way to become aware if someone unsucribes from update request?
If so how does that work?
-
Post-Award Management in Higher Education
Hi, I'm brand new to Smartsheet and would like to know how people use it for post-award contracts & grants management. Thanks, Amy
-
CountIf And
I am looking to count how many audit types, "DD", did my auditor "Brian" do. I am referencing and different sheet. =COUNTIF({MB Intake Audits - 2024 Type of Audit}, "DD", AND({MB Intake Audits - 2024 Auditor Name}, "Brian"))