-
Help with IF formula using Today formula and unparseable error
I have entered the following formula into a text/number column and I'm getting an unparseable error. I have checked the that column headers are spelled correctly. =IF(AND([% Complete]2 < 1, TODAY() >[Finish]2), "At Risk", "Normal")) I want the sheet to check if a task is not yet marked complete (<100 %) AND the current…
-
countifs formula to sum not blank dates
Hello ~ I'm new to the community and working with the COUNTIFS formula. Help would be much appreciated if you can see the error of my ways. What I want to do seems simple - I have a "Date Completed" column, defined as a Date type, and want to count how many times it's been entered in the column. I saw a thread earlier that…
-
Using COUNTIF to find the number of Blank Spaces
I'm trying to count how many blank spaces there are in a given column. However, whenever I put in the below formula, it just gives me the total amount of rows in the column, but the entire column is not blank: =COUNTIFS({CDVL Project Tasklist Range 4}, "") I've also tried this formula, but to the same results:…
-
% Date calculation
Hello, I need to create a % calculation for the number of dates meeting a 'launch' date. What is the best formula to use for this? I will have a long list of dates and I need one column to calculate how many of them are equal to or less than a launch date (25/03/2021). Any guidance would be greatly appreciated. Thanks,…
-
applying vacation or unavailable time to resources
Hello, I am an MS project user and in that program you could denote unavailable time for resources so when a task assigned to that person fell on an unavailable time period, the start and end dates accomodated for that automatically. Is there a way to do that in SS? thank you, Karen
-
C# SDK - A strongly-named assembly is required
Edit - I started from scratch rebuilding it, and that solved whatever bug was causing the issue. I still have no idea what was wrong. I'm using Visual studio/C# to make a dll for Office/VBA automation. This was working until the TLS 1.0 deprecation on 3/31. I updated the SDK to to the newest version using the NuGet manager…
-
Checking Some Children Rows but Not All
Hi everyone, I'm somewhat new to Smartsheet and I'm still learning about formulas and functions. I have a parent row and 4 children row. If all 4 children rows are checked, that's great but it's most important that the last 3 are checked in order for the parent row to automatically be checked. I set up a function.…
-
T-shirt size icons for visual icons?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
-
Legends on Calendar
Is it was possible to add a color legard on the calendar view? I noticed someone else asked a year ago and wondering if maybe Smartsheet made this possible. See screenshot.
-
Uploading Users / Resources
Aloha, new to Smartsheet set up from scratch. Using free 30 day trial and tried to load users (80), but seems it surpassed the max allowed number. do you guys know how many we can use? Also, please help understand how to avoid sending email notifications even when the upload FAILED. Thanks!